QueryCtes<R, F extends Fields> extension

Creates a CTE from selections without declared named output fields.

Selected flat projections expose their named fields through ProjectedSql. Other SQL selections retain their original expression references.

on

• Query<R, F>

Methods

asCte(String name) → DerivedQuery<R, CteFields<F>, Selection<R>>

Available on Query<R, F>, provided by the QueryCtes extension

Names this SQL query for reuse. Constructing the CTE performs no I/O.