The tree MUST have the nodes of queries (select with its items, sources, WHERE, GROUP BY, HAVING, ORDER BY, LIMIT, OFFSET; set-op of UNION, INTERSECT and EXCEPT with ALL or DISTINCT; values; with with its common table expressions, recursive or not, with their column lists), of sources (a table with its alias and column list, a subquery with LATERAL, a table function, a join of each type with ON or USING, natural or not), of data changes (insert, update, delete, each with RETURNING), and of definitions (create-table with columns, types and constraints, create-index, create-view, alter-table with its actions, drop).
Enforced (check): .github: cd commons/lang-sql && bun run verify — suite/tree.test.ts: queries, sources, data changes and definitions have the nodes and fields the specification lists
Proved by: lang-sql/suite/tree.test.ts
Tests: passed: suite/tree.test.ts queries, sources, data changes and definitions have the nodes and fields the specification
Cited by: ast