DerivedQuery<R, F extends Fields, S extends Selection<R>> class final

A query over an explicitly named common table expression.

Scalar and positional selections expose CteFields.ref. Named projections expose their declared output fields. Both forms are queries immediately and create independent join occurrences with alias.

Inheritance
Available extensions

Properties

database → QueryContext
The compilation or execution context that owns this query.
finalinherited
dependencies → ({bool opaque, Set<TableSchema> tables})
Physical read dependencies used by subscriptions, including relation batches.
no setterinherited
hashCode → int
The hash code for this object.
no setterinherited
runtimeType → Type
A representation of the runtime type of the object.
no setterinherited

Methods

alias() → TableAlias<R, F>
Creates a fresh occurrence of this CTE for a join or self join.
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.
asCte(String name) → DerivedQuery<R, O, Projection<R, O>>

Available on SelectedQuery<R, F, Projection<R, O>>, provided by the ProjectedSql extension

Exports named output slots into a fresh SQL scope.
bind(QueryContext context) → SelectedQuery<R, F, S>
Rebind the root description to an execution context. Nested queries retain their original context and are rejected when they do not match.
inherited
compile() → SqlCommand
Validates and compiles SQL with separately bound parameters, without I/O.
inherited
copyQuery(QueryState state) → SelectedQuery<R, F, S>
@nodoc
inherited
count({ExecutionOptions options = const ExecutionOptions()}) → Future<int>
Counts the query's result rows, including its limit, offset and grouping.
inherited
cursorToken(List<CursorTerm> cursor(F)) → String

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

Versioned, lossless cursor transport. This is pagination input, not an authorization token. The next query still applies its own WHERE policies.
distinct() → SelectedQuery<R, F, S>
Removes duplicate SQL projections before any Dart mapping.
inherited
exists({ExecutionOptions options = const ExecutionOptions()}) → Future<bool>
Checks whether the current query yields at least one row.
inherited
existsExpression() → Expr<bool>
Builds a SQL EXISTS expression without executing a read.
inherited
first({ExecutionOptions options = const ExecutionOptions()}) → Future<R>
Returns the first selected row, or throws QUERY.CARDINALITY if empty.
inherited
firstOrNull({ExecutionOptions options = const ExecutionOptions()}) → Future<R?>
Returns the first selected row, or null when the query is empty.
inherited
get({ExecutionOptions options = const ExecutionOptions()}) → Future<List<R>>
Executes the query and decodes all selected rows.
inherited
groupBy(List<Expr<Object?>> group(F)) → SelectedQuery<R, F, S>
Replaces SQL grouping expressions; selected non-aggregates must be grouped.
inherited
having(Expr<bool?> condition(F)) → SelectedQuery<R, F, S>
Adds an aggregate filter with AND to the existing HAVING clause.
inherited
inspect() → QueryPlan
Inspects SQL and conditional relation batches without acquiring a connection. This does not ask the database optimizer for an execution plan.
inherited
join<T, G extends Fields>(TableAlias<T, G> alias, {required Expr<bool?> on(F, G)}) → SelectedQuery<R, F, S>
Adds an inner join using an independently created table alias.
inherited
leftJoin<T, G extends Fields>(TableAlias<T, G> alias, {required Expr<bool?> on(F, G)}) → SelectedQuery<R, F, S>
Adds a left join; use the alias's optional selection for absent rows.
inherited
map<S>(S mapper(R)) → Query<S, F>
Maps decoded rows in Dart. This does not create SQL columns or change database DISTINCT/UNION semantics; compose SQL set operations first.
inherited
noSuchMethod(Invocation invocation) → dynamic
Invoked when a nonexistent method or property is accessed.
inherited
orderBy(List<OrderTerm> order(F)) → SelectedQuery<R, F, S>
Replaces the query's ordering with the supplied expressions.
inherited
scalar() → Expr<R?>
Converts a scalar selection into a nullable SQL subquery.
inherited
seekAfter(List<CursorTerm> cursor(F)) → Query<R, F>

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

Adds a lexicographic boundary after cursor and replaces query ordering.
seekToken(String token, {required List<OrderTerm> orderBy(F)}) → Query<R, F>

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

Restores a cursorToken using the expected table and complete sort order.
select<S extends Selection<T>, T>(S selection(F)) → SelectedQuery<T, F, S>

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

Chooses selected SQL cells and the application result decoded from them.
single({ExecutionOptions options = const ExecutionOptions()}) → Future<R>
Returns exactly one selected row or throws QUERY.CARDINALITY.
inherited
singleOrNull({ExecutionOptions options = const ExecutionOptions()}) → Future<R?>
Returns the only selected row, or null when empty.
inherited
skip(int count) → SelectedQuery<R, F, S>
Replaces the row offset; count must be nonnegative.
inherited
stream({int batchSize = 128, ExecutionOptions options = const ExecutionOptions()}) → Stream<R>

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

One database cursor, fetched on demand. Related rows are loaded per root batch on the same connection. Pause/await-for consumption provides demand.
take(int count) → SelectedQuery<R, F, S>
Replaces the row limit; count must be nonnegative.
inherited
toString() → String
A string representation of this object.
inherited
union<G extends Fields>(SelectedQuery<R, G, Projection<R, O>> other) → SelectedQuery<R, O, Projection<R, O>>

Available on SelectedQuery<R, F, Projection<R, O>>, provided by the ProjectedSql extension

Combines rows from the same projection declaration, removing duplicates.
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.
unionAll<G extends Fields>(SelectedQuery<R, G, Projection<R, O>> other) → SelectedQuery<R, O, Projection<R, O>>

Available on SelectedQuery<R, F, Projection<R, O>>, provided by the ProjectedSql extension

Combines matching SQL rows, preserving duplicates.
watch({Iterable<TableSchema> reads = const [], ExecutionOptions options = const ExecutionOptions()}) → Stream<List<R>>

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

Initial snapshot followed by fresh snapshots after relevant committed writes. Add tables hidden inside raw SQL with reads. Read errors are emitted without closing the stream, allowing a later invalidation to retry the query.
where(Expr<bool?> condition(F)) → SelectedQuery<R, F, S>
Adds a predicate with AND, preserving any existing filter.
inherited

Operators

operator ==(Object other) → bool
The equality operator.
inherited