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]) extends Query[T, A]

Attributes

Companion
object
Graph
Supertypes
trait Query[T, A]
class Object
trait Matchable
class Any

Members list

Value members

Concrete methods

infix def crossJoin(table: TableSchema[_] | AliasQuery[_, _] | JoinTable)(using inWithQuery: InWithQuery): Select[T, A]
infix def crossJoinLateral(table: AliasQuery[_, _])(using inWithQuery: InWithQuery): 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[_, _])(using inWithQuery: InWithQuery): Select[T, A]
infix def fromLateral(table: AliasQuery[_, _])(using inWithQuery: InWithQuery): Select[T, A]
infix def fullJoin(table: TableSchema[_] | AliasQuery[_, _] | JoinTable)(using inWithQuery: InWithQuery): Select[T, A]
infix def fullJoinLateral(table: AliasQuery[_, _])(using inWithQuery: InWithQuery): Select[T, A]
override def getAst: SqlQuery

Attributes

Definition Classes
override def getSelectItems: Map[String, String]

Attributes

Definition Classes
infix def groupBy(group: Expr[_]*): Select[T, A]
infix def having(expr: Expr[Boolean]): Select[T, A]
infix def innerJoin(table: TableSchema[_] | AliasQuery[_, _] | JoinTable)(using inWithQuery: InWithQuery): Select[T, A]
infix def innerJoinLateral(table: AliasQuery[_, _])(using inWithQuery: InWithQuery): Select[T, A]
infix def join(table: TableSchema[_] | AliasQuery[_, _] | JoinTable)(using inWithQuery: InWithQuery): Select[T, A]
infix def joinLateral(table: AliasQuery[_, _])(using inWithQuery: InWithQuery): Select[T, A]
infix def leftJoin(table: TableSchema[_] | AliasQuery[_, _] | JoinTable)(using inWithQuery: InWithQuery): Select[T, A]
infix def leftJoinLateral(table: AliasQuery[_, _])(using inWithQuery: InWithQuery): 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)(using inWithQuery: InWithQuery): Select[T, A]
infix def rightJoinLateral(table: AliasQuery[_, _])(using inWithQuery: InWithQuery): 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]
infix def where(expr: Expr[Boolean]): Select[T, A]
def where(test: => Boolean, expr: Expr[Boolean]): Select[T, A]

Inherited methods

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

Attributes

Inherited from:
Query
infix def except[RT <: Tuple](right: List[RT]): Union[UnionType[T, RT], A]

Attributes

Inherited from:
Query
infix def except[RT <: Tuple](right: RT): Union[UnionType[T, RT], A]

Attributes

Inherited from:
Query
infix def except[RT <: Tuple](right: Query[RT, _]): Union[UnionType[T, RT], A]

Attributes

Inherited from:
Query
infix def exceptAll[RT <: Tuple](right: List[RT]): Union[UnionType[T, RT], A]

Attributes

Inherited from:
Query
infix def exceptAll[RT <: Tuple](right: RT): Union[UnionType[T, RT], A]

Attributes

Inherited from:
Query
infix def exceptAll[RT <: Tuple](right: Query[RT, _]): Union[UnionType[T, RT], A]

Attributes

Inherited from:
Query
infix def intersect[RT <: Tuple](right: List[RT]): Union[UnionType[T, RT], A]

Attributes

Inherited from:
Query
infix def intersect[RT <: Tuple](right: RT): Union[UnionType[T, RT], A]

Attributes

Inherited from:
Query
infix def intersect[RT <: Tuple](right: Query[RT, _]): Union[UnionType[T, RT], A]

Attributes

Inherited from:
Query
infix def intersectAll[RT <: Tuple](right: List[RT]): Union[UnionType[T, RT], A]

Attributes

Inherited from:
Query
infix def intersectAll[RT <: Tuple](right: RT): Union[UnionType[T, RT], A]

Attributes

Inherited from:
Query
infix def intersectAll[RT <: Tuple](right: Query[RT, _]): Union[UnionType[T, RT], A]

Attributes

Inherited from:
Query
infix def union[RT <: Tuple](right: List[RT]): Union[UnionType[T, RT], A]

Attributes

Inherited from:
Query
infix def union[RT <: Tuple](right: RT): Union[UnionType[T, RT], A]

Attributes

Inherited from:
Query
infix def union[RT <: Tuple](right: Query[RT, _]): Union[UnionType[T, RT], A]

Attributes

Inherited from:
Query
infix def unionAll[RT <: Tuple](right: List[RT]): Union[UnionType[T, RT], A]

Attributes

Inherited from:
Query
infix def unionAll[RT <: Tuple](right: RT): Union[UnionType[T, RT], A]

Attributes

Inherited from:
Query
infix def unionAll[RT <: Tuple](right: Query[RT, _]): Union[UnionType[T, RT], A]

Attributes

Inherited from:
Query
def unionClause[RT <: Tuple](unionType: SqlUnionType, right: List[RT]): Union[UnionType[T, RT], A]

Attributes

Inherited from:
Query
def unionClause[RT <: Tuple](unionType: SqlUnionType, right: RT): Union[UnionType[T, RT], A]

Attributes

Inherited from:
Query
def unionClause[RT <: Tuple](unionType: SqlUnionType, right: Query[RT, _]): Union[UnionType[T, RT], A]

Attributes

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

Attributes

Inherited from:
Query