LateralJoinOps

scalasql.query.LateralJoinOps
class LateralJoinOps[C[_, _], Q, R](wrapped: JoinOps[C, Q, R] & Joinable[Q, R])(implicit qr: Row[Q, R])

Wrapper class with extension methods to add support for JOIN LATERAL, which allow for JOIN clauses to access the results of earlier JOIN and FROM clauses. Only supported by Postgres and MySql

Attributes

Graph
Supertypes
class Object
trait Matchable
class Any

Members list

Value members

Concrete methods

def crossJoinLateral[Q2, R2, QF, RF](other: Q => Joinable[Q2, R2])(implicit ja: JoinAppend[Q, Q2, QF, RF]): C[QF, RF]

Performs a CROSS JOIN LATERAL, similar to CROSS JOIN but allows the JOIN clause to access the results of earlier JOIN and FROM clauses. Only supported by Postgres and MySql

Performs a CROSS JOIN LATERAL, similar to CROSS JOIN but allows the JOIN clause to access the results of earlier JOIN and FROM clauses. Only supported by Postgres and MySql

Attributes

def crossJoinLateral[Q2, R2](): Mapper[Q, Q2, R, R2]

Version of crossJoinLateral meant for use in for-comprehensions

Version of crossJoinLateral meant for use in for-comprehensions

Attributes

def joinLateral[Q2, R2, QF, RF](other: Q => Joinable[Q2, R2])(on: (Q, Q2) => Expr[Boolean])(implicit ja: JoinAppend[Q, Q2, QF, RF]): C[QF, RF]

Performs a JOIN LATERAL, similar to JOIN but allows the JOIN clause to access the results of earlier JOIN and FROM clauses. Only supported by Postgres and MySql

Performs a JOIN LATERAL, similar to JOIN but allows the JOIN clause to access the results of earlier JOIN and FROM clauses. Only supported by Postgres and MySql

Attributes

def joinLateral[Q2, R2](on: Q => Expr[Boolean]): Mapper[Q, Q2, R, R2]

Version of joinLateral meant for use in for-comprehensions

Version of joinLateral meant for use in for-comprehensions

Attributes

def leftJoinLateral[Q2, R2](other: Q => Joinable[Q2, R2])(on: (Q, Q2) => Expr[Boolean])(implicit joinQr: Row[Q2, R2]): Select[(Q, JoinNullable[Q2]), (R, Option[R2])]
def leftJoinLateral[Q2, R2](on: Q => Expr[Boolean]): NullableMapper[Q, Q2, R, R2]

Version of leftJoinLateral meant for use in for-comprehensions

Version of leftJoinLateral meant for use in for-comprehensions

Attributes