Maybe so. Even simpler recursion doesn't get executed, such as a quick poll of the sqlite_master table to trigger a system-wide count(*) of all tables isn't allowed, so it seems that it's held at the gate. Even if I mock up a transaction or a thorough UNION set through a view, I need to output it just to read in as an update.
Regards. Brian P Curley On Mar 7, 2017 7:30 AM, "Clemens Ladisch" <clem...@ladisch.de> wrote: > Brian Curley wrote: > > What I wonder though is if CTEs could actually serve as a stand-in for > the > > lack of Dynamic SQL > > Recursive CTEs make SQL Turing complete. > > But they cannot do everything. For example, when you want to do a pivot > operation, the number of columns is determined by the data, and you > cannot construct and execute that query only from within SQLite. > > > Regards, > Clemens > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users