A common table expression inside a view definition.
query takes a nested ViewDefinition — the SQL-free form — and still accepts the raw SelectOptions and string forms the dialect understands.
query
SelectOptions
Name the CTE is referenced by (and by itself, when recursive).
The CTE body.
Optional
Emit WITH RECURSIVE.
WITH RECURSIVE
Explicit column list: name (col1, col2) AS (...).
name (col1, col2) AS (...)
A common table expression inside a view definition.
querytakes a nested ViewDefinition — the SQL-free form — and still accepts the rawSelectOptionsand string forms the dialect understands.