JoinExtension<T extends OrmEntity> extension

Methods

crossJoin(Object table, [Object? constraint, Object? operator, Object? second]) → Query<T>

Available on Query<T>, provided by the JoinExtension extension

Adds a CROSS JOIN clause to the query. When constraint is omitted, a simple CROSS JOIN table is emitted.

crossJoinSub(Query query, String alias, [Object? constraint, Object? operator, Object? second]) → Query<T>

Available on Query<T>, provided by the JoinExtension extension

Adds a CROSS JOIN against a subquery.

join(Object table, Object constraint, [Object? operator, Object? second]) → Query<T>

Available on Query<T>, provided by the JoinExtension extension

Adds an INNER JOIN clause to the query.

joinLateral(Query query, String alias, {JoinType type = JoinType.inner, JoinConstraintBuilder? on}) → Query<T>

Available on Query<T>, provided by the JoinExtension extension

Adds a (driver-gated) LATERAL JOIN clause.

joinSub(Query query, String alias, Object constraint, [Object? operator, Object? second]) → Query<T>

Available on Query<T>, provided by the JoinExtension extension

Adds an INNER JOIN against a subquery.

joinWhere(Object table, Object column, [Object? operator, Object? value]) → Query<T>

Available on Query<T>, provided by the JoinExtension extension

Adds an INNER JOIN ... WHERE clause to the query.

leftJoin(Object table, Object constraint, [Object? operator, Object? second]) → Query<T>

Available on Query<T>, provided by the JoinExtension extension

Adds a LEFT JOIN clause to the query.

leftJoinLateral(Query query, String alias, {JoinConstraintBuilder? on}) → Query<T>

Available on Query<T>, provided by the JoinExtension extension

Adds a LEFT JOIN LATERAL clause.

leftJoinSub(Query query, String alias, Object constraint, [Object? operator, Object? second]) → Query<T>

Available on Query<T>, provided by the JoinExtension extension

Adds a LEFT JOIN against a subquery.

leftJoinWhere(Object table, Object column, [Object? operator, Object? value]) → Query<T>

Available on Query<T>, provided by the JoinExtension extension

Adds a LEFT JOIN ... WHERE clause to the query.

rightJoin(Object table, Object constraint, [Object? operator, Object? second]) → Query<T>

Available on Query<T>, provided by the JoinExtension extension

Adds a RIGHT JOIN clause to the query.

rightJoinSub(Query query, String alias, Object constraint, [Object? operator, Object? second]) → Query<T>

Available on Query<T>, provided by the JoinExtension extension

Adds a RIGHT JOIN against a subquery.

rightJoinWhere(Object table, Object column, [Object? operator, Object? value]) → Query<T>

Available on Query<T>, provided by the JoinExtension extension

Adds a RIGHT JOIN ... WHERE clause to the query.

straightJoin(Object table, Object constraint, [Object? operator, Object? second]) → Query<T>

Available on Query<T>, provided by the JoinExtension extension

Adds a STRAIGHT_JOIN clause (MySQL / MariaDB only).