core

API

easysql.ast

easysql.ast.expr

SqlBinaryOperator

easysql.ast.statement

easysql.query.nonselect

Generated with

core/easysql.query.select/Select

Select

easysql.query.select.Select

See theSelect companion object

class Select[T <: Tuple, A <: Tuple](val ast: SqlSelect, selectItems: Map[String, String], joinLeft: Option[SqlTable])

Attributes

Companion:: object
Graph
Supertypes: class Object
trait Matchable
class Any

Members list

Concise view

Value members

Concrete methods

infix def as(name: String)(using name.type != "" =:= true): AliasQuery[T, A]

infix def crossJoin(table: TableSchema[_] | AliasQuery[_, _] | JoinTable): Select[T, A]

infix def crossJoinLateral(table: AliasQuery[_, _]): Select[T, A]

def distinct: Select[T, A]

infix def dynamicsSelect(columns: Expr[_] | AliasExpr[_, _]*): Select[EmptyTuple, EmptyTuple]

def forUpdate: Select[T, A]

infix def from(table: TableSchema[_]): Select[T, A]

infix def from(table: AliasQuery[_, _]): Select[T, A]

infix def fromLateral(table: AliasQuery[_, _]): Select[T, A]

infix def fullJoin(table: TableSchema[_] | AliasQuery[_, _] | JoinTable): Select[T, A]

infix def fullJoinLateral(table: AliasQuery[_, _]): Select[T, A]

infix def groupBy(group: Expr[_]*): Select[T, A]

infix def having(expr: Expr[Boolean]): Select[T, A]

infix def innerJoin(table: TableSchema[_] | AliasQuery[_, _] | JoinTable): Select[T, A]

infix def innerJoinLateral(table: AliasQuery[_, _]): Select[T, A]

infix def join(table: TableSchema[_] | AliasQuery[_, _] | JoinTable): Select[T, A]

infix def joinLateral(table: AliasQuery[_, _]): Select[T, A]

infix def leftJoin(table: TableSchema[_] | AliasQuery[_, _] | JoinTable): Select[T, A]

infix def leftJoinLateral(table: AliasQuery[_, _]): Select[T, A]

infix def limit(count: Int): Select[T, A]

infix def offset(count: Int): Select[T, A]

infix def on(expr: Expr[Boolean]): Select[T, A]

infix def orderBy(order: OrderBy*): Select[T, A]

infix def rightJoin(table: TableSchema[_] | AliasQuery[_, _] | JoinTable): Select[T, A]

infix def rightJoinLateral(table: AliasQuery[_, _]): Select[T, A]

infix def select[U <: Tuple](items: U): Select[Concat[T, InverseMap[U]], Concat[A, AliasNames[U]]]

infix def select[I <: SqlDataType, E <: Expr[I]](item: E): Select[Concat[T, (I)], Concat[A, AliasNames[(E)]]]

infix def select[I <: SqlDataType, N <: String](item: AliasExpr[I, N]): Select[Concat[T, (I)], Concat[A, (N)]]

infix def select[P <: Product](table: TableSchema[P]): Select[Concat[T, (P)], A]

def toExpr: SubQueryExpr[T]

Extension method from Select

def unsafeAs(name: String): AliasQuery[T, A]

infix def where(expr: Expr[Boolean]): Select[T, A]

def where(test: () => Boolean, expr: Expr[Boolean]): Select[T, A]

def where(test: Boolean, expr: Expr[Boolean]): Select[T, A]

Generated with