compound-select-stmt WITH RECURSIVE common-table-expression , select-core ORDER BY LIMIT expr UNION UNION ALL select-core INTERSECT EXCEPT ordering-term , OFFSET expr , expr References: common-table-expression expr ordering-term select-core See also: lang_select.html SQLite is in the Public Domain. https://sqlite.org/syntax/compound-select-stmt.html