... stmt conflict-clause create-index-stmt create-table-stmt create-trigger-stmt create-view-stmt create-virtual-table-stmt cte-table-name delete-stmt delete-stmt-limited detach-stmt drop-index-stmt drop-table-stmt drop-trigger-stmt drop-view ... 

 ... That ordinary CTE is a view that can be used to find all parents of any individual. That ordinary CTE is then used in the "ancestor_of_alice" recursive CTE. The recursive CTE is then used in the final query: WITH RECURSIVE ... 

 ... Used by:   sql-stmt See also:   lang_createvtab.html cte-table-name: Used by:   recursive-cte   with-clause See also:   lang_with.html   lang_with.html#recursivecte delete-stmt: Used by ... 

11. Subquery Flattening  ... The subquery may not be a recursive CTE. (Subsumed into constraint 17d.) (Obsolete. Query flattening is no longer attempted for aggregate subqueries.) Query flattening is an important optimization when views are used as each use of a view is translated ...