SetQueries<R, F extends Fields> extension

SQL set operations over matching scalar or positional Record projections.

Both operands must belong to the same database or transaction context. Apply Dart mapping after combining SQL rows; a DTO mapper does not define SQL set equality. Constructing a set query performs no database I/O.

on

• Query<R, F>

Methods

union<G extends Fields>(Query<R, G> other) → Query<R, UnionFields<F>>

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

Combines SQL scalars or .row projections. Both operands must use this database/session and the same codecs, column types and nullability.

unionAll<G extends Fields>(Query<R, G> other) → Query<R, UnionFields<F>>

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

Keeps duplicate SQL rows. Row order requires an explicit final orderBy.