OrderedQuery1<A> extension

Extension methods for a query returning zero or more rows with 1 expression.

on

Properties

first → QuerySingle<(Expr<A>)>: Available on OrderedQuery<(Expr<A>)>, provided by the OrderedQuery1 extension
Limit Query to the first row using LIMIT clause.
no setter

fetch() → Future<List<A>>: Available on OrderedQuery<(Expr<A>)>, provided by the OrderedQuery1 extension
Query the database for rows in this Query as a List.
limit(int limit) → OrderedQueryRange<(Expr<A>)>: Available on OrderedQuery<(Expr<A>)>, provided by the OrderedQuery1 extension
Limit OrderedQuery using LIMIT clause.
offset(int offset) → OrderedQueryRange<(Expr<A>)>: Available on OrderedQuery<(Expr<A>)>, provided by the OrderedQuery1 extension
Offset OrderedQuery using OFFSET clause.
orderBy(List<(Expr<Comparable?>, Order)> builder(Expr<A> a)) → OrderedQuery<(Expr<A>)>: Available on OrderedQuery<(Expr<A>)>, provided by the OrderedQuery1 extension
Order OrderedQuery using ORDER BY clause.
select<T extends Record>(T projectionBuilder(Expr<A> a)) → ProjectedOrderedQuery<T>: Available on OrderedQuery<(Expr<A>)>, provided by the OrderedQuery1 extension
Create a projection of this OrderedQuery using SELECT clause.
stream() → Stream<A>: Available on OrderedQuery<(Expr<A>)>, provided by the OrderedQuery1 extension
Query the database for rows in this Query as a Stream.
where(Expr<bool> conditionBuilder(Expr<A> a)) → OrderedQuery<(Expr<A>)>: Available on OrderedQuery<(Expr<A>)>, provided by the OrderedQuery1 extension
Filter OrderedQuery using WHERE clause.