Query<T extends Record> class
final
Writing queries
A Query on the database from which results can be fetched.
- Implementers
- Available extensions
Properties
-
asSubQuery
→ SubQuery<
T> -
Available on Query<
Use this Query as a SubQuery.T> , provided by the QueryExt extensionno setter -
first
→ QuerySingle<
(Expr< A> )> -
Available on Query<
Limit Query to the first row using(Expr< , provided by the Query1 extensionA> )>LIMIT
clause.no setter -
first
→ QuerySingle<
(Expr< A> , Expr<B> )> -
Available on Query<
Limit Query to the first row using(Expr< , provided by the Query2 extensionA> , Expr<B> )>LIMIT
clause.no setter -
first
→ QuerySingle<
(Expr< A> , Expr<B> , Expr<C> )> -
Available on Query<
Limit Query to the first row using(Expr< , provided by the Query3 extensionA> , Expr<B> , Expr<C> )>LIMIT
clause.no setter -
first
→ QuerySingle<
(Expr< A> , Expr<B> , Expr<C> , Expr<D> )> -
Available on Query<
Limit Query to the first row using(Expr< , provided by the Query4 extensionA> , Expr<B> , Expr<C> , Expr<D> )>LIMIT
clause.no setter -
first
→ QuerySingle<
(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> )> -
Available on Query<
Limit Query to the first row using(Expr< , provided by the Query5 extensionA> , Expr<B> , Expr<C> , Expr<D> , Expr<E> )>LIMIT
clause.no setter -
first
→ QuerySingle<
(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> )> -
Available on Query<
Limit Query to the first row using(Expr< , provided by the Query6 extensionA> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> )>LIMIT
clause.no setter -
first
→ QuerySingle<
(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> )> -
Available on Query<
Limit Query to the first row using(Expr< , provided by the Query7 extensionA> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> )>LIMIT
clause.no setter -
first
→ QuerySingle<
(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> , Expr<H> )> -
Available on Query<
Limit Query to the first row using(Expr< , provided by the Query8 extensionA> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> , Expr<H> )>LIMIT
clause.no setter - hashCode → int
-
The hash code for this object.
no setterinherited
- runtimeType → Type
-
A representation of the runtime type of the object.
no setterinherited
Methods
-
avg(
) → QuerySingle< (Expr< double?> )> -
Available on Query<
Take the average of the rows in this query using the(Expr< , provided by the QueryReal extensiondouble?> )>AVG
aggregate function. -
avg(
) → QuerySingle< (Expr< double?> )> -
Available on Query<
Take the average of the rows in this query using the(Expr< , provided by the QueryInteger extensionint?> )>AVG
aggregate function. -
count(
) → QuerySingle< (Expr< int> )> -
Available on Query<
Count number of rows in this Query using(Expr< , provided by the Query4 extensionA> , Expr<B> , Expr<C> , Expr<D> )>COUNT(*)
aggregate function. -
count(
) → QuerySingle< (Expr< int> )> -
Available on Query<
Count number of rows in this Query using(Expr< , provided by the Query1 extensionA> )>COUNT(*)
aggregate function. -
count(
) → QuerySingle< (Expr< int> )> -
Available on Query<
Count number of rows in this Query using(Expr< , provided by the Query2 extensionA> , Expr<B> )>COUNT(*)
aggregate function. -
count(
) → QuerySingle< (Expr< int> )> -
Available on Query<
Count number of rows in this Query using(Expr< , provided by the Query7 extensionA> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> )>COUNT(*)
aggregate function. -
count(
) → QuerySingle< (Expr< int> )> -
Available on Query<
Count number of rows in this Query using(Expr< , provided by the Query8 extensionA> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> , Expr<H> )>COUNT(*)
aggregate function. -
count(
) → QuerySingle< (Expr< int> )> -
Available on Query<
Count number of rows in this Query using(Expr< , provided by the Query6 extensionA> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> )>COUNT(*)
aggregate function. -
count(
) → QuerySingle< (Expr< int> )> -
Available on Query<
Count number of rows in this Query using(Expr< , provided by the Query3 extensionA> , Expr<B> , Expr<C> )>COUNT(*)
aggregate function. -
count(
) → QuerySingle< (Expr< int> )> -
Available on Query<
Count number of rows in this Query using(Expr< , provided by the Query5 extensionA> , Expr<B> , Expr<C> , Expr<D> , Expr<E> )>COUNT(*)
aggregate function. -
distinct(
) → Query< T> -
Available on Query<
Create a query with distinct rows from this query using theT> , provided by the QueryExt extensionDISTINCT
keyword. -
except(
Query< (Expr< other) → Query<A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> )>(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> )> -
Available on Query<
Combine this Query with(Expr< , provided by the Query6 extensionA> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> )>other
usingEXCEPT
set operator. -
except(
Query< (Expr< other) → Query<A> , Expr<B> , Expr<C> )>(Expr< A> , Expr<B> , Expr<C> )> -
Available on Query<
Combine this Query with(Expr< , provided by the Query3 extensionA> , Expr<B> , Expr<C> )>other
usingEXCEPT
set operator. -
except(
Query< (Expr< other) → Query<A> )>(Expr< A> )> -
Available on Query<
Combine this Query with(Expr< , provided by the Query1 extensionA> )>other
usingEXCEPT
set operator. -
except(
Query< (Expr< other) → Query<A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> )>(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> )> -
Available on Query<
Combine this Query with(Expr< , provided by the Query7 extensionA> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> )>other
usingEXCEPT
set operator. -
except(
Query< (Expr< other) → Query<A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> , Expr<H> )>(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> , Expr<H> )> -
Available on Query<
Combine this Query with(Expr< , provided by the Query8 extensionA> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> , Expr<H> )>other
usingEXCEPT
set operator. -
except(
Query< (Expr< other) → Query<A> , Expr<B> )>(Expr< A> , Expr<B> )> -
Available on Query<
Combine this Query with(Expr< , provided by the Query2 extensionA> , Expr<B> )>other
usingEXCEPT
set operator. -
except(
Query< (Expr< other) → Query<A> , Expr<B> , Expr<C> , Expr<D> )>(Expr< A> , Expr<B> , Expr<C> , Expr<D> )> -
Available on Query<
Combine this Query with(Expr< , provided by the Query4 extensionA> , Expr<B> , Expr<C> , Expr<D> )>other
usingEXCEPT
set operator. -
except(
Query< (Expr< other) → Query<A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> )>(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> )> -
Available on Query<
Combine this Query with(Expr< , provided by the Query5 extensionA> , Expr<B> , Expr<C> , Expr<D> , Expr<E> )>other
usingEXCEPT
set operator. -
exists(
) → QuerySingle< (Expr< bool> )> -
Available on Query<
Check for existance of rows in this Query using(Expr< , provided by the Query7 extensionA> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> )>EXISTS
operator. -
exists(
) → QuerySingle< (Expr< bool> )> -
Available on Query<
Check for existance of rows in this Query using(Expr< , provided by the Query4 extensionA> , Expr<B> , Expr<C> , Expr<D> )>EXISTS
operator. -
exists(
) → QuerySingle< (Expr< bool> )> -
Available on Query<
Check for existance of rows in this Query using(Expr< , provided by the Query2 extensionA> , Expr<B> )>EXISTS
operator. -
exists(
) → QuerySingle< (Expr< bool> )> -
Available on Query<
Check for existance of rows in this Query using(Expr< , provided by the Query6 extensionA> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> )>EXISTS
operator. -
exists(
) → QuerySingle< (Expr< bool> )> -
Available on Query<
Check for existance of rows in this Query using(Expr< , provided by the Query1 extensionA> )>EXISTS
operator. -
exists(
) → QuerySingle< (Expr< bool> )> -
Available on Query<
Check for existance of rows in this Query using(Expr< , provided by the Query5 extensionA> , Expr<B> , Expr<C> , Expr<D> , Expr<E> )>EXISTS
operator. -
exists(
) → QuerySingle< (Expr< bool> )> -
Available on Query<
Check for existance of rows in this Query using(Expr< , provided by the Query3 extensionA> , Expr<B> , Expr<C> )>EXISTS
operator. -
exists(
) → QuerySingle< (Expr< bool> )> -
Available on Query<
Check for existance of rows in this Query using(Expr< , provided by the Query8 extensionA> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> , Expr<H> )>EXISTS
operator. -
fetch(
) → Future< List< (A, B, C, D)> > -
Available on Query<
Query the database for rows in this Query as a List.(Expr< , provided by the Query4 extensionA> , Expr<B> , Expr<C> , Expr<D> )> -
fetch(
) → Future< List< A> > -
Available on Query<
Query the database for rows in this Query as a List.(Expr< , provided by the Query1 extensionA> )> -
fetch(
) → Future< List< (A, B)> > -
Available on Query<
Query the database for rows in this Query as a List.(Expr< , provided by the Query2 extensionA> , Expr<B> )> -
fetch(
) → Future< List< (A, B, C, D, E, F, G)> > -
Available on Query<
Query the database for rows in this Query as a List.(Expr< , provided by the Query7 extensionA> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> )> -
fetch(
) → Future< List< (A, B, C, D, E)> > -
Available on Query<
Query the database for rows in this Query as a List.(Expr< , provided by the Query5 extensionA> , Expr<B> , Expr<C> , Expr<D> , Expr<E> )> -
fetch(
) → Future< List< (A, B, C)> > -
Available on Query<
Query the database for rows in this Query as a List.(Expr< , provided by the Query3 extensionA> , Expr<B> , Expr<C> )> -
fetch(
) → Future< List< (A, B, C, D, E, F, G, H)> > -
Available on Query<
Query the database for rows in this Query as a List.(Expr< , provided by the Query8 extensionA> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> , Expr<H> )> -
fetch(
) → Future< List< (A, B, C, D, E, F)> > -
Available on Query<
Query the database for rows in this Query as a List.(Expr< , provided by the Query6 extensionA> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> )> -
groupBy<
T extends Record> (T groupBuilder(Expr< A> a, Expr<B> b)) → Group<T, (Expr< A> , Expr<B> )> -
Available on Query<
Create projection for(Expr< , provided by the Query2 extensionA> , Expr<B> )>GROUP BY
clause. -
groupBy<
T extends Record> (T groupBuilder(Expr< A> a, Expr<B> b, Expr<C> c, Expr<D> d, Expr<E> e, Expr<F> f)) → Group<T, (Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> )> -
Available on Query<
Create projection for(Expr< , provided by the Query6 extensionA> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> )>GROUP BY
clause. -
groupBy<
T extends Record> (T groupBuilder(Expr< A> a, Expr<B> b, Expr<C> c, Expr<D> d, Expr<E> e)) → Group<T, (Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> )> -
Available on Query<
Create projection for(Expr< , provided by the Query5 extensionA> , Expr<B> , Expr<C> , Expr<D> , Expr<E> )>GROUP BY
clause. -
groupBy<
T extends Record> (T groupBuilder(Expr< A> a)) → Group<T, (Expr< A> )> -
Available on Query<
Create projection for(Expr< , provided by the Query1 extensionA> )>GROUP BY
clause. -
groupBy<
T extends Record> (T groupBuilder(Expr< A> a, Expr<B> b, Expr<C> c, Expr<D> d, Expr<E> e, Expr<F> f, Expr<G> g, Expr<H> h)) → Group<T, (Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> , Expr<H> )> -
Available on Query<
Create projection for(Expr< , provided by the Query8 extensionA> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> , Expr<H> )>GROUP BY
clause. -
groupBy<
T extends Record> (T groupBuilder(Expr< A> a, Expr<B> b, Expr<C> c, Expr<D> d)) → Group<T, (Expr< A> , Expr<B> , Expr<C> , Expr<D> )> -
Available on Query<
Create projection for(Expr< , provided by the Query4 extensionA> , Expr<B> , Expr<C> , Expr<D> )>GROUP BY
clause. -
groupBy<
T extends Record> (T groupBuilder(Expr< A> a, Expr<B> b, Expr<C> c, Expr<D> d, Expr<E> e, Expr<F> f, Expr<G> g)) → Group<T, (Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> )> -
Available on Query<
Create projection for(Expr< , provided by the Query7 extensionA> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> )>GROUP BY
clause. -
groupBy<
T extends Record> (T groupBuilder(Expr< A> a, Expr<B> b, Expr<C> c)) → Group<T, (Expr< A> , Expr<B> , Expr<C> )> -
Available on Query<
Create projection for(Expr< , provided by the Query3 extensionA> , Expr<B> , Expr<C> )>GROUP BY
clause. -
intersect(
Query< (Expr< other) → Query<A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> )>(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> )> -
Available on Query<
Combine this Query with(Expr< , provided by the Query6 extensionA> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> )>other
usingINTERSECT
set operator. -
intersect(
Query< (Expr< other) → Query<A> )>(Expr< A> )> -
Available on Query<
Combine this Query with(Expr< , provided by the Query1 extensionA> )>other
usingINTERSECT
set operator. -
intersect(
Query< (Expr< other) → Query<A> , Expr<B> )>(Expr< A> , Expr<B> )> -
Available on Query<
Combine this Query with(Expr< , provided by the Query2 extensionA> , Expr<B> )>other
usingINTERSECT
set operator. -
intersect(
Query< (Expr< other) → Query<A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> )>(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> )> -
Available on Query<
Combine this Query with(Expr< , provided by the Query7 extensionA> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> )>other
usingINTERSECT
set operator. -
intersect(
Query< (Expr< other) → Query<A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> , Expr<H> )>(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> , Expr<H> )> -
Available on Query<
Combine this Query with(Expr< , provided by the Query8 extensionA> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> , Expr<H> )>other
usingINTERSECT
set operator. -
intersect(
Query< (Expr< other) → Query<A> , Expr<B> , Expr<C> )>(Expr< A> , Expr<B> , Expr<C> )> -
Available on Query<
Combine this Query with(Expr< , provided by the Query3 extensionA> , Expr<B> , Expr<C> )>other
usingINTERSECT
set operator. -
intersect(
Query< (Expr< other) → Query<A> , Expr<B> , Expr<C> , Expr<D> )>(Expr< A> , Expr<B> , Expr<C> , Expr<D> )> -
Available on Query<
Combine this Query with(Expr< , provided by the Query4 extensionA> , Expr<B> , Expr<C> , Expr<D> )>other
usingINTERSECT
set operator. -
intersect(
Query< (Expr< other) → Query<A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> )>(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> )> -
Available on Query<
Combine this Query with(Expr< , provided by the Query5 extensionA> , Expr<B> , Expr<C> , Expr<D> , Expr<E> )>other
usingINTERSECT
set operator. -
join<
T extends Record> (Query< T> query) → InnerJoin<(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> ), T> -
Available on Query<
Join this Query with another Query using(Expr< , provided by the Query5 extensionA> , Expr<B> , Expr<C> , Expr<D> , Expr<E> )>INNER JOIN
clause. -
join<
T extends Record> (Query< T> query) → InnerJoin<(Expr< A> , Expr<B> , Expr<C> ), T> -
Available on Query<
Join this Query with another Query using(Expr< , provided by the Query3 extensionA> , Expr<B> , Expr<C> )>INNER JOIN
clause. -
join<
T extends Record> (Query< T> query) → InnerJoin<(Expr< A> ), T> -
Available on Query<
Join this Query with another Query using(Expr< , provided by the Query1 extensionA> )>INNER JOIN
clause. -
join<
T extends Record> (Query< T> query) → InnerJoin<(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> , Expr<H> ), T> -
Available on Query<
Join this Query with another Query using(Expr< , provided by the Query8 extensionA> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> , Expr<H> )>INNER JOIN
clause. -
join<
T extends Record> (Query< T> query) → InnerJoin<(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> ), T> -
Available on Query<
Join this Query with another Query using(Expr< , provided by the Query7 extensionA> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> )>INNER JOIN
clause. -
join<
T extends Record> (Query< T> query) → InnerJoin<(Expr< A> , Expr<B> , Expr<C> , Expr<D> ), T> -
Available on Query<
Join this Query with another Query using(Expr< , provided by the Query4 extensionA> , Expr<B> , Expr<C> , Expr<D> )>INNER JOIN
clause. -
join<
T extends Record> (Query< T> query) → InnerJoin<(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> ), T> -
Available on Query<
Join this Query with another Query using(Expr< , provided by the Query6 extensionA> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> )>INNER JOIN
clause. -
join<
T extends Record> (Query< T> query) → InnerJoin<(Expr< A> , Expr<B> ), T> -
Available on Query<
Join this Query with another Query using(Expr< , provided by the Query2 extensionA> , Expr<B> )>INNER JOIN
clause. -
leftJoin<
T extends Record> (Query< T> query) → LeftJoin<(Expr< A> , Expr<B> , Expr<C> , Expr<D> ), T> -
Available on Query<
Join this Query with another Query using(Expr< , provided by the Query4 extensionA> , Expr<B> , Expr<C> , Expr<D> )>LEFT JOIN
clause. -
leftJoin<
T extends Record> (Query< T> query) → LeftJoin<(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> ), T> -
Available on Query<
Join this Query with another Query using(Expr< , provided by the Query5 extensionA> , Expr<B> , Expr<C> , Expr<D> , Expr<E> )>LEFT JOIN
clause. -
leftJoin<
T extends Record> (Query< T> query) → LeftJoin<(Expr< A> , Expr<B> , Expr<C> ), T> -
Available on Query<
Join this Query with another Query using(Expr< , provided by the Query3 extensionA> , Expr<B> , Expr<C> )>LEFT JOIN
clause. -
leftJoin<
T extends Record> (Query< T> query) → LeftJoin<(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> ), T> -
Available on Query<
Join this Query with another Query using(Expr< , provided by the Query6 extensionA> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> )>LEFT JOIN
clause. -
leftJoin<
T extends Record> (Query< T> query) → LeftJoin<(Expr< A> , Expr<B> ), T> -
Available on Query<
Join this Query with another Query using(Expr< , provided by the Query2 extensionA> , Expr<B> )>LEFT JOIN
clause. -
leftJoin<
T extends Record> (Query< T> query) → LeftJoin<(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> ), T> -
Available on Query<
Join this Query with another Query using(Expr< , provided by the Query7 extensionA> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> )>LEFT JOIN
clause. -
leftJoin<
T extends Record> (Query< T> query) → LeftJoin<(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> , Expr<H> ), T> -
Available on Query<
Join this Query with another Query using(Expr< , provided by the Query8 extensionA> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> , Expr<H> )>LEFT JOIN
clause. -
leftJoin<
T extends Record> (Query< T> query) → LeftJoin<(Expr< A> ), T> -
Available on Query<
Join this Query with another Query using(Expr< , provided by the Query1 extensionA> )>LEFT JOIN
clause. -
limit(
int limit) → Query< (Expr< A> , Expr<B> , Expr<C> , Expr<D> )> -
Available on Query<
Limit Query using(Expr< , provided by the Query4 extensionA> , Expr<B> , Expr<C> , Expr<D> )>LIMIT
clause. -
limit(
int limit) → Query< (Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> )> -
Available on Query<
Limit Query using(Expr< , provided by the Query5 extensionA> , Expr<B> , Expr<C> , Expr<D> , Expr<E> )>LIMIT
clause. -
limit(
int limit) → Query< (Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> )> -
Available on Query<
Limit Query using(Expr< , provided by the Query6 extensionA> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> )>LIMIT
clause. -
limit(
int limit) → Query< (Expr< A> , Expr<B> , Expr<C> )> -
Available on Query<
Limit Query using(Expr< , provided by the Query3 extensionA> , Expr<B> , Expr<C> )>LIMIT
clause. -
limit(
int limit) → Query< (Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> )> -
Available on Query<
Limit Query using(Expr< , provided by the Query7 extensionA> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> )>LIMIT
clause. -
limit(
int limit) → Query< (Expr< A> , Expr<B> )> -
Available on Query<
Limit Query using(Expr< , provided by the Query2 extensionA> , Expr<B> )>LIMIT
clause. -
limit(
int limit) → Query< (Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> , Expr<H> )> -
Available on Query<
Limit Query using(Expr< , provided by the Query8 extensionA> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> , Expr<H> )>LIMIT
clause. -
limit(
int limit) → Query< (Expr< A> )> -
Available on Query<
Limit Query using(Expr< , provided by the Query1 extensionA> )>LIMIT
clause. -
max(
) → QuerySingle< (Expr< DateTime?> )> -
Available on Query<
Take the largest row of the rows in this query using the(Expr< , provided by the QueryDateTime extensionDateTime?> )>MAX
aggregate function. -
max(
) → QuerySingle< (Expr< double?> )> -
Available on Query<
Take the largest row of the rows in this query using the(Expr< , provided by the QueryReal extensiondouble?> )>MAX
aggregate function. -
max(
) → QuerySingle< (Expr< String?> )> -
Available on Query<
Take the largest row of the rows in this query using the(Expr< , provided by the QueryString extensionString?> )>MAX
aggregate function. -
max(
) → QuerySingle< (Expr< int?> )> -
Available on Query<
Take the largest row of the rows in this query using the(Expr< , provided by the QueryInteger extensionint?> )>MAX
aggregate function. -
min(
) → QuerySingle< (Expr< String?> )> -
Available on Query<
Take the smallest row of the rows in this query using the(Expr< , provided by the QueryString extensionString?> )>MIN
aggregate function. -
min(
) → QuerySingle< (Expr< double?> )> -
Available on Query<
Take the smallest row of the rows in this query using the(Expr< , provided by the QueryReal extensiondouble?> )>MIN
aggregate function. -
min(
) → QuerySingle< (Expr< int?> )> -
Available on Query<
Take the smallest row of the rows in this query using the(Expr< , provided by the QueryInteger extensionint?> )>MIN
aggregate function. -
min(
) → QuerySingle< (Expr< DateTime?> )> -
Available on Query<
Take the smallest row of the rows in this query using the(Expr< , provided by the QueryDateTime extensionDateTime?> )>MIN
aggregate function. -
noSuchMethod(
Invocation invocation) → dynamic -
Invoked when a nonexistent method or property is accessed.
inherited
-
offset(
int offset) → Query< (Expr< A> )> -
Available on Query<
Offset Query using(Expr< , provided by the Query1 extensionA> )>OFFSET
clause. -
offset(
int offset) → Query< (Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> , Expr<H> )> -
Available on Query<
Offset Query using(Expr< , provided by the Query8 extensionA> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> , Expr<H> )>OFFSET
clause. -
offset(
int offset) → Query< (Expr< A> , Expr<B> , Expr<C> , Expr<D> )> -
Available on Query<
Offset Query using(Expr< , provided by the Query4 extensionA> , Expr<B> , Expr<C> , Expr<D> )>OFFSET
clause. -
offset(
int offset) → Query< (Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> )> -
Available on Query<
Offset Query using(Expr< , provided by the Query6 extensionA> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> )>OFFSET
clause. -
offset(
int offset) → Query< (Expr< A> , Expr<B> , Expr<C> )> -
Available on Query<
Offset Query using(Expr< , provided by the Query3 extensionA> , Expr<B> , Expr<C> )>OFFSET
clause. -
offset(
int offset) → Query< (Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> )> -
Available on Query<
Offset Query using(Expr< , provided by the Query5 extensionA> , Expr<B> , Expr<C> , Expr<D> , Expr<E> )>OFFSET
clause. -
offset(
int offset) → Query< (Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> )> -
Available on Query<
Offset Query using(Expr< , provided by the Query7 extensionA> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> )>OFFSET
clause. -
offset(
int offset) → Query< (Expr< A> , Expr<B> )> -
Available on Query<
Offset Query using(Expr< , provided by the Query2 extensionA> , Expr<B> )>OFFSET
clause. -
orderBy(
List< (Expr< builder(Expr<Comparable?> , Order)>A> a, Expr<B> b, Expr<C> c, Expr<D> d, Expr<E> e, Expr<F> f, Expr<G> g, Expr<H> h)) → OrderedQuery<(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> , Expr<H> )> -
Available on Query<
Order Query using(Expr< , provided by the Query8 extensionA> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> , Expr<H> )>ORDER BY
clause. -
orderBy(
List< (Expr< builder(Expr<Comparable?> , Order)>A> a, Expr<B> b, Expr<C> c, Expr<D> d, Expr<E> e)) → OrderedQuery<(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> )> -
Available on Query<
Order Query using(Expr< , provided by the Query5 extensionA> , Expr<B> , Expr<C> , Expr<D> , Expr<E> )>ORDER BY
clause. -
orderBy(
List< (Expr< builder(Expr<Comparable?> , Order)>A> a, Expr<B> b, Expr<C> c, Expr<D> d, Expr<E> e, Expr<F> f)) → OrderedQuery<(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> )> -
Available on Query<
Order Query using(Expr< , provided by the Query6 extensionA> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> )>ORDER BY
clause. -
orderBy(
List< (Expr< builder(Expr<Comparable?> , Order)>A> a, Expr<B> b, Expr<C> c)) → OrderedQuery<(Expr< A> , Expr<B> , Expr<C> )> -
Available on Query<
Order Query using(Expr< , provided by the Query3 extensionA> , Expr<B> , Expr<C> )>ORDER BY
clause. -
orderBy(
List< (Expr< builder(Expr<Comparable?> , Order)>A> a, Expr<B> b, Expr<C> c, Expr<D> d, Expr<E> e, Expr<F> f, Expr<G> g)) → OrderedQuery<(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> )> -
Available on Query<
Order Query using(Expr< , provided by the Query7 extensionA> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> )>ORDER BY
clause. -
orderBy(
List< (Expr< builder(Expr<Comparable?> , Order)>A> a, Expr<B> b, Expr<C> c, Expr<D> d)) → OrderedQuery<(Expr< A> , Expr<B> , Expr<C> , Expr<D> )> -
Available on Query<
Order Query using(Expr< , provided by the Query4 extensionA> , Expr<B> , Expr<C> , Expr<D> )>ORDER BY
clause. -
orderBy(
List< (Expr< builder(Expr<Comparable?> , Order)>A> a)) → OrderedQuery<(Expr< A> )> -
Available on Query<
Order Query using(Expr< , provided by the Query1 extensionA> )>ORDER BY
clause. -
orderBy(
List< (Expr< builder(Expr<Comparable?> , Order)>A> a, Expr<B> b)) → OrderedQuery<(Expr< A> , Expr<B> )> -
Available on Query<
Order Query using(Expr< , provided by the Query2 extensionA> , Expr<B> )>ORDER BY
clause. -
rightJoin<
T extends Record> (Query< T> query) → RightJoin<(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> ), T> -
Available on Query<
Join this Query with another Query using(Expr< , provided by the Query6 extensionA> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> )>RIGHT JOIN
clause. -
rightJoin<
T extends Record> (Query< T> query) → RightJoin<(Expr< A> ), T> -
Available on Query<
Join this Query with another Query using(Expr< , provided by the Query1 extensionA> )>RIGHT JOIN
clause. -
rightJoin<
T extends Record> (Query< T> query) → RightJoin<(Expr< A> , Expr<B> ), T> -
Available on Query<
Join this Query with another Query using(Expr< , provided by the Query2 extensionA> , Expr<B> )>RIGHT JOIN
clause. -
rightJoin<
T extends Record> (Query< T> query) → RightJoin<(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> , Expr<H> ), T> -
Available on Query<
Join this Query with another Query using(Expr< , provided by the Query8 extensionA> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> , Expr<H> )>RIGHT JOIN
clause. -
rightJoin<
T extends Record> (Query< T> query) → RightJoin<(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> ), T> -
Available on Query<
Join this Query with another Query using(Expr< , provided by the Query7 extensionA> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> )>RIGHT JOIN
clause. -
rightJoin<
T extends Record> (Query< T> query) → RightJoin<(Expr< A> , Expr<B> , Expr<C> ), T> -
Available on Query<
Join this Query with another Query using(Expr< , provided by the Query3 extensionA> , Expr<B> , Expr<C> )>RIGHT JOIN
clause. -
rightJoin<
T extends Record> (Query< T> query) → RightJoin<(Expr< A> , Expr<B> , Expr<C> , Expr<D> ), T> -
Available on Query<
Join this Query with another Query using(Expr< , provided by the Query4 extensionA> , Expr<B> , Expr<C> , Expr<D> )>RIGHT JOIN
clause. -
rightJoin<
T extends Record> (Query< T> query) → RightJoin<(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> ), T> -
Available on Query<
Join this Query with another Query using(Expr< , provided by the Query5 extensionA> , Expr<B> , Expr<C> , Expr<D> , Expr<E> )>RIGHT JOIN
clause. -
select<
T extends Record> (T projectionBuilder(Expr< A> a, Expr<B> b, Expr<C> c)) → Query<T> -
Available on Query<
Create a projection of this Query using(Expr< , provided by the Query3 extensionA> , Expr<B> , Expr<C> )>SELECT
clause. -
select<
T extends Record> (T projectionBuilder(Expr< A> a)) → Query<T> -
Available on Query<
Create a projection of this Query using(Expr< , provided by the Query1 extensionA> )>SELECT
clause. -
select<
T extends Record> (T projectionBuilder(Expr< A> a, Expr<B> b)) → Query<T> -
Available on Query<
Create a projection of this Query using(Expr< , provided by the Query2 extensionA> , Expr<B> )>SELECT
clause. -
select<
T extends Record> (T projectionBuilder(Expr< A> a, Expr<B> b, Expr<C> c, Expr<D> d, Expr<E> e, Expr<F> f, Expr<G> g)) → Query<T> -
Available on Query<
Create a projection of this Query using(Expr< , provided by the Query7 extensionA> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> )>SELECT
clause. -
select<
T extends Record> (T projectionBuilder(Expr< A> a, Expr<B> b, Expr<C> c, Expr<D> d, Expr<E> e, Expr<F> f, Expr<G> g, Expr<H> h)) → Query<T> -
Available on Query<
Create a projection of this Query using(Expr< , provided by the Query8 extensionA> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> , Expr<H> )>SELECT
clause. -
select<
T extends Record> (T projectionBuilder(Expr< A> a, Expr<B> b, Expr<C> c, Expr<D> d, Expr<E> e)) → Query<T> -
Available on Query<
Create a projection of this Query using(Expr< , provided by the Query5 extensionA> , Expr<B> , Expr<C> , Expr<D> , Expr<E> )>SELECT
clause. -
select<
T extends Record> (T projectionBuilder(Expr< A> a, Expr<B> b, Expr<C> c, Expr<D> d)) → Query<T> -
Available on Query<
Create a projection of this Query using(Expr< , provided by the Query4 extensionA> , Expr<B> , Expr<C> , Expr<D> )>SELECT
clause. -
select<
T extends Record> (T projectionBuilder(Expr< A> a, Expr<B> b, Expr<C> c, Expr<D> d, Expr<E> e, Expr<F> f)) → Query<T> -
Available on Query<
Create a projection of this Query using(Expr< , provided by the Query6 extensionA> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> )>SELECT
clause. -
stream(
) → Stream< (A, B)> -
Available on Query<
Query the database for rows in this Query as a Stream.(Expr< , provided by the Query2 extensionA> , Expr<B> )> -
stream(
) → Stream< (A, B, C, D, E, F, G, H)> -
Available on Query<
Query the database for rows in this Query as a Stream.(Expr< , provided by the Query8 extensionA> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> , Expr<H> )> -
stream(
) → Stream< (A, B, C, D, E, F)> -
Available on Query<
Query the database for rows in this Query as a Stream.(Expr< , provided by the Query6 extensionA> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> )> -
stream(
) → Stream< (A, B, C, D, E)> -
Available on Query<
Query the database for rows in this Query as a Stream.(Expr< , provided by the Query5 extensionA> , Expr<B> , Expr<C> , Expr<D> , Expr<E> )> -
stream(
) → Stream< (A, B, C, D)> -
Available on Query<
Query the database for rows in this Query as a Stream.(Expr< , provided by the Query4 extensionA> , Expr<B> , Expr<C> , Expr<D> )> -
stream(
) → Stream< (A, B, C)> -
Available on Query<
Query the database for rows in this Query as a Stream.(Expr< , provided by the Query3 extensionA> , Expr<B> , Expr<C> )> -
stream(
) → Stream< A> -
Available on Query<
Query the database for rows in this Query as a Stream.(Expr< , provided by the Query1 extensionA> )> -
stream(
) → Stream< (A, B, C, D, E, F, G)> -
Available on Query<
Query the database for rows in this Query as a Stream.(Expr< , provided by the Query7 extensionA> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> )> -
sum(
) → QuerySingle< (Expr< double> )> -
Available on Query<
Take the sum of the rows in this query using the(Expr< , provided by the QueryReal extensiondouble?> )>SUM
aggregate function. -
sum(
) → QuerySingle< (Expr< int> )> -
Available on Query<
Take the sum of the rows in this query using the(Expr< , provided by the QueryInteger extensionint?> )>SUM
aggregate function. -
toString(
) → String -
A string representation of this object.
inherited
-
union(
Query< (Expr< other) → Query<A> )>(Expr< A> )> -
Available on Query<
Combine this Query with(Expr< , provided by the Query1 extensionA> )>other
usingUNION
set operator. -
union(
Query< (Expr< other) → Query<A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> )>(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> )> -
Available on Query<
Combine this Query with(Expr< , provided by the Query7 extensionA> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> )>other
usingUNION
set operator. -
union(
Query< (Expr< other) → Query<A> , Expr<B> , Expr<C> )>(Expr< A> , Expr<B> , Expr<C> )> -
Available on Query<
Combine this Query with(Expr< , provided by the Query3 extensionA> , Expr<B> , Expr<C> )>other
usingUNION
set operator. -
union(
Query< (Expr< other) → Query<A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> , Expr<H> )>(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> , Expr<H> )> -
Available on Query<
Combine this Query with(Expr< , provided by the Query8 extensionA> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> , Expr<H> )>other
usingUNION
set operator. -
union(
Query< (Expr< other) → Query<A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> )>(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> )> -
Available on Query<
Combine this Query with(Expr< , provided by the Query5 extensionA> , Expr<B> , Expr<C> , Expr<D> , Expr<E> )>other
usingUNION
set operator. -
union(
Query< (Expr< other) → Query<A> , Expr<B> )>(Expr< A> , Expr<B> )> -
Available on Query<
Combine this Query with(Expr< , provided by the Query2 extensionA> , Expr<B> )>other
usingUNION
set operator. -
union(
Query< (Expr< other) → Query<A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> )>(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> )> -
Available on Query<
Combine this Query with(Expr< , provided by the Query6 extensionA> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> )>other
usingUNION
set operator. -
union(
Query< (Expr< other) → Query<A> , Expr<B> , Expr<C> , Expr<D> )>(Expr< A> , Expr<B> , Expr<C> , Expr<D> )> -
Available on Query<
Combine this Query with(Expr< , provided by the Query4 extensionA> , Expr<B> , Expr<C> , Expr<D> )>other
usingUNION
set operator. -
unionAll(
Query< (Expr< other) → Query<A> )>(Expr< A> )> -
Available on Query<
Combine this Query with(Expr< , provided by the Query1 extensionA> )>other
usingUNION ALL
set operator. -
unionAll(
Query< (Expr< other) → Query<A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> )>(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> )> -
Available on Query<
Combine this Query with(Expr< , provided by the Query7 extensionA> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> )>other
usingUNION ALL
set operator. -
unionAll(
Query< (Expr< other) → Query<A> , Expr<B> , Expr<C> , Expr<D> )>(Expr< A> , Expr<B> , Expr<C> , Expr<D> )> -
Available on Query<
Combine this Query with(Expr< , provided by the Query4 extensionA> , Expr<B> , Expr<C> , Expr<D> )>other
usingUNION ALL
set operator. -
unionAll(
Query< (Expr< other) → Query<A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> , Expr<H> )>(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> , Expr<H> )> -
Available on Query<
Combine this Query with(Expr< , provided by the Query8 extensionA> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> , Expr<H> )>other
usingUNION ALL
set operator. -
unionAll(
Query< (Expr< other) → Query<A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> )>(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> )> -
Available on Query<
Combine this Query with(Expr< , provided by the Query5 extensionA> , Expr<B> , Expr<C> , Expr<D> , Expr<E> )>other
usingUNION ALL
set operator. -
unionAll(
Query< (Expr< other) → Query<A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> )>(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> )> -
Available on Query<
Combine this Query with(Expr< , provided by the Query6 extensionA> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> )>other
usingUNION ALL
set operator. -
unionAll(
Query< (Expr< other) → Query<A> , Expr<B> )>(Expr< A> , Expr<B> )> -
Available on Query<
Combine this Query with(Expr< , provided by the Query2 extensionA> , Expr<B> )>other
usingUNION ALL
set operator. -
unionAll(
Query< (Expr< other) → Query<A> , Expr<B> , Expr<C> )>(Expr< A> , Expr<B> , Expr<C> )> -
Available on Query<
Combine this Query with(Expr< , provided by the Query3 extensionA> , Expr<B> , Expr<C> )>other
usingUNION ALL
set operator. -
where(
Expr< bool> conditionBuilder(Expr<A> a, Expr<B> b, Expr<C> c, Expr<D> d, Expr<E> e, Expr<F> f, Expr<G> g)) → Query<(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> )> -
Available on Query<
Filter Query using(Expr< , provided by the Query7 extensionA> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> )>WHERE
clause. -
where(
Expr< bool> conditionBuilder(Expr<A> a, Expr<B> b, Expr<C> c, Expr<D> d, Expr<E> e, Expr<F> f, Expr<G> g, Expr<H> h)) → Query<(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> , Expr<H> )> -
Available on Query<
Filter Query using(Expr< , provided by the Query8 extensionA> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> , Expr<H> )>WHERE
clause. -
where(
Expr< bool> conditionBuilder(Expr<A> a, Expr<B> b)) → Query<(Expr< A> , Expr<B> )> -
Available on Query<
Filter Query using(Expr< , provided by the Query2 extensionA> , Expr<B> )>WHERE
clause. -
where(
Expr< bool> conditionBuilder(Expr<A> a, Expr<B> b, Expr<C> c)) → Query<(Expr< A> , Expr<B> , Expr<C> )> -
Available on Query<
Filter Query using(Expr< , provided by the Query3 extensionA> , Expr<B> , Expr<C> )>WHERE
clause. -
where(
Expr< bool> conditionBuilder(Expr<A> a, Expr<B> b, Expr<C> c, Expr<D> d, Expr<E> e, Expr<F> f)) → Query<(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> )> -
Available on Query<
Filter Query using(Expr< , provided by the Query6 extensionA> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> )>WHERE
clause. -
where(
Expr< bool> conditionBuilder(Expr<A> a, Expr<B> b, Expr<C> c, Expr<D> d, Expr<E> e)) → Query<(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> )> -
Available on Query<
Filter Query using(Expr< , provided by the Query5 extensionA> , Expr<B> , Expr<C> , Expr<D> , Expr<E> )>WHERE
clause. -
where(
Expr< bool> conditionBuilder(Expr<A> a, Expr<B> b, Expr<C> c, Expr<D> d)) → Query<(Expr< A> , Expr<B> , Expr<C> , Expr<D> )> -
Available on Query<
Filter Query using(Expr< , provided by the Query4 extensionA> , Expr<B> , Expr<C> , Expr<D> )>WHERE
clause. -
where(
Expr< bool> conditionBuilder(Expr<A> a)) → Query<(Expr< A> )> -
Available on Query<
Filter Query using(Expr< , provided by the Query1 extensionA> )>WHERE
clause.
Operators
-
operator &(
Query< (Expr< other) → Query<A> )>(Expr< A> )> -
Available on Query<
Combine this Query with(Expr< , provided by the Query1 extensionA> )>other
usingINTERSECT
set operator. -
operator &(
Query< (Expr< other) → Query<A> , Expr<B> )>(Expr< A> , Expr<B> )> -
Available on Query<
Combine this Query with(Expr< , provided by the Query2 extensionA> , Expr<B> )>other
usingINTERSECT
set operator. -
operator &(
Query< (Expr< other) → Query<A> , Expr<B> , Expr<C> )>(Expr< A> , Expr<B> , Expr<C> )> -
Available on Query<
Combine this Query with(Expr< , provided by the Query3 extensionA> , Expr<B> , Expr<C> )>other
usingINTERSECT
set operator. -
operator &(
Query< (Expr< other) → Query<A> , Expr<B> , Expr<C> , Expr<D> )>(Expr< A> , Expr<B> , Expr<C> , Expr<D> )> -
Available on Query<
Combine this Query with(Expr< , provided by the Query4 extensionA> , Expr<B> , Expr<C> , Expr<D> )>other
usingINTERSECT
set operator. -
operator &(
Query< (Expr< other) → Query<A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> )>(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> )> -
Available on Query<
Combine this Query with(Expr< , provided by the Query5 extensionA> , Expr<B> , Expr<C> , Expr<D> , Expr<E> )>other
usingINTERSECT
set operator. -
operator &(
Query< (Expr< other) → Query<A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> )>(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> )> -
Available on Query<
Combine this Query with(Expr< , provided by the Query6 extensionA> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> )>other
usingINTERSECT
set operator. -
operator &(
Query< (Expr< other) → Query<A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> )>(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> )> -
Available on Query<
Combine this Query with(Expr< , provided by the Query7 extensionA> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> )>other
usingINTERSECT
set operator. -
operator &(
Query< (Expr< other) → Query<A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> , Expr<H> )>(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> , Expr<H> )> -
Available on Query<
Combine this Query with(Expr< , provided by the Query8 extensionA> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> , Expr<H> )>other
usingINTERSECT
set operator. -
operator +(
Query< (Expr< other) → Query<A> )>(Expr< A> )> -
Available on Query<
Combine this Query with(Expr< , provided by the Query1 extensionA> )>other
usingUNION ALL
set operator. -
operator +(
Query< (Expr< other) → Query<A> , Expr<B> )>(Expr< A> , Expr<B> )> -
Available on Query<
Combine this Query with(Expr< , provided by the Query2 extensionA> , Expr<B> )>other
usingUNION ALL
set operator. -
operator +(
Query< (Expr< other) → Query<A> , Expr<B> , Expr<C> )>(Expr< A> , Expr<B> , Expr<C> )> -
Available on Query<
Combine this Query with(Expr< , provided by the Query3 extensionA> , Expr<B> , Expr<C> )>other
usingUNION ALL
set operator. -
operator +(
Query< (Expr< other) → Query<A> , Expr<B> , Expr<C> , Expr<D> )>(Expr< A> , Expr<B> , Expr<C> , Expr<D> )> -
Available on Query<
Combine this Query with(Expr< , provided by the Query4 extensionA> , Expr<B> , Expr<C> , Expr<D> )>other
usingUNION ALL
set operator. -
operator +(
Query< (Expr< other) → Query<A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> )>(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> )> -
Available on Query<
Combine this Query with(Expr< , provided by the Query5 extensionA> , Expr<B> , Expr<C> , Expr<D> , Expr<E> )>other
usingUNION ALL
set operator. -
operator +(
Query< (Expr< other) → Query<A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> )>(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> )> -
Available on Query<
Combine this Query with(Expr< , provided by the Query6 extensionA> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> )>other
usingUNION ALL
set operator. -
operator +(
Query< (Expr< other) → Query<A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> )>(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> )> -
Available on Query<
Combine this Query with(Expr< , provided by the Query7 extensionA> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> )>other
usingUNION ALL
set operator. -
operator +(
Query< (Expr< other) → Query<A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> , Expr<H> )>(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> , Expr<H> )> -
Available on Query<
Combine this Query with(Expr< , provided by the Query8 extensionA> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> , Expr<H> )>other
usingUNION ALL
set operator. -
operator -(
Query< (Expr< other) → Query<A> )>(Expr< A> )> -
Available on Query<
Combine this Query with(Expr< , provided by the Query1 extensionA> )>other
usingUNION
set operator. -
operator -(
Query< (Expr< other) → Query<A> , Expr<B> )>(Expr< A> , Expr<B> )> -
Available on Query<
Combine this Query with(Expr< , provided by the Query2 extensionA> , Expr<B> )>other
usingUNION
set operator. -
operator -(
Query< (Expr< other) → Query<A> , Expr<B> , Expr<C> )>(Expr< A> , Expr<B> , Expr<C> )> -
Available on Query<
Combine this Query with(Expr< , provided by the Query3 extensionA> , Expr<B> , Expr<C> )>other
usingUNION
set operator. -
operator -(
Query< (Expr< other) → Query<A> , Expr<B> , Expr<C> , Expr<D> )>(Expr< A> , Expr<B> , Expr<C> , Expr<D> )> -
Available on Query<
Combine this Query with(Expr< , provided by the Query4 extensionA> , Expr<B> , Expr<C> , Expr<D> )>other
usingUNION
set operator. -
operator -(
Query< (Expr< other) → Query<A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> )>(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> )> -
Available on Query<
Combine this Query with(Expr< , provided by the Query5 extensionA> , Expr<B> , Expr<C> , Expr<D> , Expr<E> )>other
usingUNION
set operator. -
operator -(
Query< (Expr< other) → Query<A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> )>(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> )> -
Available on Query<
Combine this Query with(Expr< , provided by the Query6 extensionA> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> )>other
usingUNION
set operator. -
operator -(
Query< (Expr< other) → Query<A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> )>(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> )> -
Available on Query<
Combine this Query with(Expr< , provided by the Query7 extensionA> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> )>other
usingUNION
set operator. -
operator -(
Query< (Expr< other) → Query<A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> , Expr<H> )>(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> , Expr<H> )> -
Available on Query<
Combine this Query with(Expr< , provided by the Query8 extensionA> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> , Expr<H> )>other
usingUNION
set operator. -
operator ==(
Object other) → bool -
The equality operator.
inherited
-
operator |(
Query< (Expr< other) → Query<A> )>(Expr< A> )> -
Available on Query<
Combine this Query with(Expr< , provided by the Query1 extensionA> )>other
usingEXCEPT
set operator. -
operator |(
Query< (Expr< other) → Query<A> , Expr<B> )>(Expr< A> , Expr<B> )> -
Available on Query<
Combine this Query with(Expr< , provided by the Query2 extensionA> , Expr<B> )>other
usingEXCEPT
set operator. -
operator |(
Query< (Expr< other) → Query<A> , Expr<B> , Expr<C> )>(Expr< A> , Expr<B> , Expr<C> )> -
Available on Query<
Combine this Query with(Expr< , provided by the Query3 extensionA> , Expr<B> , Expr<C> )>other
usingEXCEPT
set operator. -
operator |(
Query< (Expr< other) → Query<A> , Expr<B> , Expr<C> , Expr<D> )>(Expr< A> , Expr<B> , Expr<C> , Expr<D> )> -
Available on Query<
Combine this Query with(Expr< , provided by the Query4 extensionA> , Expr<B> , Expr<C> , Expr<D> )>other
usingEXCEPT
set operator. -
operator |(
Query< (Expr< other) → Query<A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> )>(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> )> -
Available on Query<
Combine this Query with(Expr< , provided by the Query5 extensionA> , Expr<B> , Expr<C> , Expr<D> , Expr<E> )>other
usingEXCEPT
set operator. -
operator |(
Query< (Expr< other) → Query<A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> )>(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> )> -
Available on Query<
Combine this Query with(Expr< , provided by the Query6 extensionA> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> )>other
usingEXCEPT
set operator. -
operator |(
Query< (Expr< other) → Query<A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> )>(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> )> -
Available on Query<
Combine this Query with(Expr< , provided by the Query7 extensionA> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> )>other
usingEXCEPT
set operator. -
operator |(
Query< (Expr< other) → Query<A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> , Expr<H> )>(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> , Expr<H> )> -
Available on Query<
Combine this Query with(Expr< , provided by the Query8 extensionA> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> , Expr<H> )>other
usingEXCEPT
set operator.