OrderedQueryRange2<A, B> extension

Extension methods for a query returning zero or more rows with 2 expressions.

on

Properties

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

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