SubQuery<T extends Record> class final Writing queries

A Query which can only be used as a subquery.

Available extensions

• QuerySubExt
• SubQuery1
• SubQuery1Ext
• SubQuery2
• SubQuery3
• SubQuery4
• SubQuery5
• SubQuery6
• SubQuery7
• SubQuery8
• SubQueryDateTime
• SubQueryInteger
• SubQueryReal
• SubQueryString

Properties

first → Expr<T?>

Available on SubQuery<(Expr<T>)>, provided by the SubQuery1Ext extension

Use the first row of this query as subquery expression.

no setter

hashCode → int

The hash code for this object.

no setter, inherited

runtimeType → Type

A representation of the runtime type of the object.

no setter, inherited

Methods

avg() → Expr<double?>

Available on SubQuery<(Expr<double?>)>, provided by the SubQueryReal extension

Take the average of the rows in this query using the AVG aggregate function.

avg() → Expr<double?>

Available on SubQuery<(Expr<int?>)>, provided by the SubQueryInteger extension

Take the average of the rows in this query using the AVG aggregate function.

count() → Expr<int>

Available on SubQuery<(Expr<A>)>, provided by the SubQuery1 extension

Count number of rows in this SubQuery using COUNT(*) aggregate function.

count() → Expr<int>

Available on SubQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>)>, provided by the SubQuery5 extension

Count number of rows in this SubQuery using COUNT(*) aggregate function.

count() → Expr<int>

Available on SubQuery<(Expr<A>, Expr<B>)>, provided by the SubQuery2 extension

Count number of rows in this SubQuery using COUNT(*) aggregate function.

count() → Expr<int>

Available on SubQuery<(Expr<A>, Expr<B>, Expr<C>)>, provided by the SubQuery3 extension

Count number of rows in this SubQuery using COUNT(*) aggregate function.

count() → Expr<int>

Available on SubQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>)>, provided by the SubQuery4 extension

Count number of rows in this SubQuery using COUNT(*) aggregate function.

count() → Expr<int>

Available on SubQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>, Expr<H>)>, provided by the SubQuery8 extension

Count number of rows in this SubQuery using COUNT(*) aggregate function.

count() → Expr<int>

Available on SubQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>)>, provided by the SubQuery6 extension

Count number of rows in this SubQuery using COUNT(*) aggregate function.

count() → Expr<int>

Available on SubQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>)>, provided by the SubQuery7 extension

Count number of rows in this SubQuery using COUNT(*) aggregate function.

distinct() → SubQuery<T>

Available on SubQuery<T>, provided by the QuerySubExt extension

Create a query with distinct rows from this query using the DISTINCT keyword.

exists() → Expr<bool>

Available on SubQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>)>, provided by the SubQuery7 extension

Check for existance of rows in this SubQuery using EXISTS operator.

exists() → Expr<bool>

Available on SubQuery<(Expr<A>)>, provided by the SubQuery1 extension

Check for existance of rows in this SubQuery using EXISTS operator.

exists() → Expr<bool>

Available on SubQuery<(Expr<A>, Expr<B>)>, provided by the SubQuery2 extension

Check for existance of rows in this SubQuery using EXISTS operator.

exists() → Expr<bool>

Available on SubQuery<(Expr<A>, Expr<B>, Expr<C>)>, provided by the SubQuery3 extension

Check for existance of rows in this SubQuery using EXISTS operator.

exists() → Expr<bool>

Available on SubQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>)>, provided by the SubQuery4 extension

Check for existance of rows in this SubQuery using EXISTS operator.

exists() → Expr<bool>

Available on SubQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>, Expr<H>)>, provided by the SubQuery8 extension

Check for existance of rows in this SubQuery using EXISTS operator.

exists() → Expr<bool>

Available on SubQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>)>, provided by the SubQuery5 extension

Check for existance of rows in this SubQuery using EXISTS operator.

exists() → Expr<bool>

Available on SubQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>)>, provided by the SubQuery6 extension

Check for existance of rows in this SubQuery using EXISTS operator.

limit(int limit) → SubQuery<(Expr<A>)>

Available on SubQuery<(Expr<A>)>, provided by the SubQuery1 extension

Limit SubQuery using LIMIT clause.

limit(int limit) → SubQuery<(Expr<A>, Expr<B>)>

Available on SubQuery<(Expr<A>, Expr<B>)>, provided by the SubQuery2 extension

Limit SubQuery using LIMIT clause.

limit(int limit) → SubQuery<(Expr<A>, Expr<B>, Expr<C>)>

Available on SubQuery<(Expr<A>, Expr<B>, Expr<C>)>, provided by the SubQuery3 extension

Limit SubQuery using LIMIT clause.

limit(int limit) → SubQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>)>

Available on SubQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>)>, provided by the SubQuery4 extension

Limit SubQuery using LIMIT clause.

limit(int limit) → SubQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>)>

Available on SubQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>)>, provided by the SubQuery5 extension

Limit SubQuery using LIMIT clause.

limit(int limit) → SubQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>)>

Available on SubQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>)>, provided by the SubQuery6 extension

Limit SubQuery using LIMIT clause.

limit(int limit) → SubQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>, Expr<H>)>

Available on SubQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>, Expr<H>)>, provided by the SubQuery8 extension

Limit SubQuery using LIMIT clause.

limit(int limit) → SubQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>)>

Available on SubQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>)>, provided by the SubQuery7 extension

Limit SubQuery using LIMIT clause.

max() → Expr<double?>

Available on SubQuery<(Expr<double?>)>, provided by the SubQueryReal extension

Take the largest row of the rows in this query using the MAX aggregate function.

max() → Expr<int?>

Available on SubQuery<(Expr<int?>)>, provided by the SubQueryInteger extension

Take the largest row of the rows in this query using the MAX aggregate function.

max() → Expr<DateTime?>

Available on SubQuery<(Expr<DateTime?>)>, provided by the SubQueryDateTime extension

Take the largest row of the rows in this query using the MAX aggregate function.

max() → Expr<String?>

Available on SubQuery<(Expr<String?>)>, provided by the SubQueryString extension

Take the largest row of the rows in this query using the MAX aggregate function.

min() → Expr<DateTime?>

Available on SubQuery<(Expr<DateTime?>)>, provided by the SubQueryDateTime extension

Take the smallest row of the rows in this query using the MIN aggregate function.

min() → Expr<int?>

Available on SubQuery<(Expr<int?>)>, provided by the SubQueryInteger extension

Take the smallest row of the rows in this query using the MIN aggregate function.

min() → Expr<double?>

Available on SubQuery<(Expr<double?>)>, provided by the SubQueryReal extension

Take the smallest row of the rows in this query using the MIN aggregate function.

min() → Expr<String?>

Available on SubQuery<(Expr<String?>)>, provided by the SubQueryString extension

Take the smallest row of the rows in this query using the MIN aggregate function.

noSuchMethod(Invocation invocation) → dynamic

Invoked when a nonexistent method or property is accessed.

inherited

offset(int offset) → SubQuery<(Expr<A>, Expr<B>)>

Available on SubQuery<(Expr<A>, Expr<B>)>, provided by the SubQuery2 extension

Offset SubQuery using OFFSET clause.

offset(int offset) → SubQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>)>

Available on SubQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>)>, provided by the SubQuery5 extension

Offset SubQuery using OFFSET clause.

offset(int offset) → SubQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>, Expr<H>)>

Available on SubQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>, Expr<H>)>, provided by the SubQuery8 extension

Offset SubQuery using OFFSET clause.

offset(int offset) → SubQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>)>

Available on SubQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>)>, provided by the SubQuery6 extension

Offset SubQuery using OFFSET clause.

offset(int offset) → SubQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>)>

Available on SubQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>)>, provided by the SubQuery4 extension

Offset SubQuery using OFFSET clause.

offset(int offset) → SubQuery<(Expr<A>)>

Available on SubQuery<(Expr<A>)>, provided by the SubQuery1 extension

Offset SubQuery using OFFSET clause.

offset(int offset) → SubQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>)>

Available on SubQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>)>, provided by the SubQuery7 extension

Offset SubQuery using OFFSET clause.

offset(int offset) → SubQuery<(Expr<A>, Expr<B>, Expr<C>)>

Available on SubQuery<(Expr<A>, Expr<B>, Expr<C>)>, provided by the SubQuery3 extension

Offset SubQuery using OFFSET clause.

orderBy(List<(Expr<Comparable?>, Order)> builder(Expr<A> a, Expr<B> b, Expr<C> c, Expr<D> d, Expr<E> e)) → OrderedSubQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>)>

Available on SubQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>)>, provided by the SubQuery5 extension

Order SubQuery using ORDER BY clause.

orderBy(List<(Expr<Comparable?>, Order)> builder(Expr<A> a, Expr<B> b)) → OrderedSubQuery<(Expr<A>, Expr<B>)>

Available on SubQuery<(Expr<A>, Expr<B>)>, provided by the SubQuery2 extension

Order SubQuery using ORDER BY clause.

orderBy(List<(Expr<Comparable?>, Order)> builder(Expr<A> a)) → OrderedSubQuery<(Expr<A>)>

Available on SubQuery<(Expr<A>)>, provided by the SubQuery1 extension

Order SubQuery using ORDER BY clause.

orderBy(List<(Expr<Comparable?>, Order)> builder(Expr<A> a, Expr<B> b, Expr<C> c, Expr<D> d, Expr<E> e, Expr<F> f)) → OrderedSubQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>)>

Available on SubQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>)>, provided by the SubQuery6 extension

Order SubQuery using ORDER BY clause.

orderBy(List<(Expr<Comparable?>, Order)> builder(Expr<A> a, Expr<B> b, Expr<C> c, Expr<D> d)) → OrderedSubQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>)>

Available on SubQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>)>, provided by the SubQuery4 extension

Order SubQuery using ORDER BY clause.

orderBy(List<(Expr<Comparable?>, Order)> builder(Expr<A> a, Expr<B> b, Expr<C> c, Expr<D> d, Expr<E> e, Expr<F> f, Expr<G> g, Expr<H> h)) → OrderedSubQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>, Expr<H>)>

Available on SubQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>, Expr<H>)>, provided by the SubQuery8 extension

Order SubQuery using ORDER BY clause.

orderBy(List<(Expr<Comparable?>, Order)> builder(Expr<A> a, Expr<B> b, Expr<C> c)) → OrderedSubQuery<(Expr<A>, Expr<B>, Expr<C>)>

Available on SubQuery<(Expr<A>, Expr<B>, Expr<C>)>, provided by the SubQuery3 extension

Order SubQuery using ORDER BY clause.

orderBy(List<(Expr<Comparable?>, Order)> builder(Expr<A> a, Expr<B> b, Expr<C> c, Expr<D> d, Expr<E> e, Expr<F> f, Expr<G> g)) → OrderedSubQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>)>

Available on SubQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>)>, provided by the SubQuery7 extension

Order SubQuery using ORDER BY 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)) → SubQuery<T>

Available on SubQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>)>, provided by the SubQuery6 extension

Create a projection of this SubQuery using SELECT clause.

select<T extends Record>(T projectionBuilder(Expr<A> a, Expr<B> b, Expr<C> c, Expr<D> d, Expr<E> e)) → SubQuery<T>

Available on SubQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>)>, provided by the SubQuery5 extension

Create a projection of this SubQuery using 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)) → SubQuery<T>

Available on SubQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>, Expr<H>)>, provided by the SubQuery8 extension

Create a projection of this SubQuery using SELECT clause.

select<T extends Record>(T projectionBuilder(Expr<A> a, Expr<B> b, Expr<C> c, Expr<D> d)) → SubQuery<T>

Available on SubQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>)>, provided by the SubQuery4 extension

Create a projection of this SubQuery using SELECT clause.

select<T extends Record>(T projectionBuilder(Expr<A> a, Expr<B> b, Expr<C> c)) → SubQuery<T>

Available on SubQuery<(Expr<A>, Expr<B>, Expr<C>)>, provided by the SubQuery3 extension

Create a projection of this SubQuery using SELECT clause.

select<T extends Record>(T projectionBuilder(Expr<A> a, Expr<B> b)) → SubQuery<T>

Available on SubQuery<(Expr<A>, Expr<B>)>, provided by the SubQuery2 extension

Create a projection of this SubQuery using SELECT clause.

select<T extends Record>(T projectionBuilder(Expr<A> a)) → SubQuery<T>

Available on SubQuery<(Expr<A>)>, provided by the SubQuery1 extension

Create a projection of this SubQuery using 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)) → SubQuery<T>

Available on SubQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>)>, provided by the SubQuery7 extension

Create a projection of this SubQuery using SELECT clause.

sum() → Expr<int>

Available on SubQuery<(Expr<int?>)>, provided by the SubQueryInteger extension

Take the sum of the rows in this query using the SUM aggregate function.

sum() → Expr<double>

Available on SubQuery<(Expr<double?>)>, provided by the SubQueryReal extension

Take the sum of the rows in this query using the SUM aggregate function.

toString() → String

A string representation of this object.

inherited

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)) → SubQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>, Expr<H>)>

Available on SubQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>, Expr<H>)>, provided by the SubQuery8 extension

Filter SubQuery using 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)) → SubQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>)>

Available on SubQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>)>, provided by the SubQuery7 extension

Filter SubQuery using WHERE clause.

where(Expr<bool> conditionBuilder(Expr<A> a, Expr<B> b, Expr<C> c, Expr<D> d, Expr<E> e, Expr<F> f)) → SubQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>)>

Available on SubQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>)>, provided by the SubQuery6 extension

Filter SubQuery using WHERE clause.

where(Expr<bool> conditionBuilder(Expr<A> a, Expr<B> b, Expr<C> c, Expr<D> d, Expr<E> e)) → SubQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>)>

Available on SubQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>)>, provided by the SubQuery5 extension

Filter SubQuery using WHERE clause.

where(Expr<bool> conditionBuilder(Expr<A> a, Expr<B> b, Expr<C> c, Expr<D> d)) → SubQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>)>

Available on SubQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>)>, provided by the SubQuery4 extension

Filter SubQuery using WHERE clause.

where(Expr<bool> conditionBuilder(Expr<A> a, Expr<B> b, Expr<C> c)) → SubQuery<(Expr<A>, Expr<B>, Expr<C>)>

Available on SubQuery<(Expr<A>, Expr<B>, Expr<C>)>, provided by the SubQuery3 extension

Filter SubQuery using WHERE clause.

where(Expr<bool> conditionBuilder(Expr<A> a, Expr<B> b)) → SubQuery<(Expr<A>, Expr<B>)>

Available on SubQuery<(Expr<A>, Expr<B>)>, provided by the SubQuery2 extension

Filter SubQuery using WHERE clause.

where(Expr<bool> conditionBuilder(Expr<A> a)) → SubQuery<(Expr<A>)>

Available on SubQuery<(Expr<A>)>, provided by the SubQuery1 extension

Filter SubQuery using WHERE clause.

Operators

operator ==(Object other) → bool

The equality operator.

inherited