OrderedQuery2<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 OrderedQuery<(Expr<A>, Expr)>, provided by the OrderedQuery2 extension
Limit Query to the first row using LIMIT clause.
no setter

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