On 10/8/2015 11:51 AM, Marc L. Allen wrote: > However, CTE is a functionality enhancement that, I believe, does not impact > the ability of previous SQLite versions to work with the database.
One could create a view, or a trigger, that uses CTE query. That's not backward-compatible. Basically, any query could in principle become part of the schema. -- Igor Tandetnik