with-clause WITH RECURSIVE cte-table-name AS NOT MATERIALIZED ( select-stmt ) MATERIALIZED , References: cte-table-name select-stmt See also: lang_with.html SQLite is in the Public Domain. https://sqlite.org/syntax/with-clause.html