core/org.easysql.query.select/Select

Select

class Select[T <: Tuple, AliasNames <: Tuple] extends SelectQuery[T, AliasNames]
Companion:
object
trait SelectQuery[T, AliasNames]
trait Dynamic
class Object
trait Matchable
class Any

Value members

Concrete methods

def countSql(db: DB): String
infix def crossJoin(table: TableSchema[_]): Select[T, AliasNames]
infix def crossJoin(query: SelectQuery[_, _]): Select[T, AliasNames]
infix def crossJoin(table: JoinTableSchema): Select[T, AliasNames]
infix def crossJoinLateral(query: SelectQuery[_, _]): Select[T, AliasNames]
def distinct: Select[T, AliasNames]
infix def dynamicSelect(columns: Expr[_] | AliasExpr[_, _]*): Select[T, AliasNames]
def forUpdate: Select[T, AliasNames]
infix def from[Table <: TableSchema[_]](table: Table): Select[T, AliasNames]
infix def from(table: SelectQuery[_, _]): Select[T, AliasNames]
infix def fromLateral(table: SelectQuery[_, _]): Select[T, AliasNames]
infix def fullJoin(table: TableSchema[_]): Select[T, AliasNames]
infix def fullJoin(query: SelectQuery[_, _]): Select[T, AliasNames]
infix def fullJoin(table: JoinTableSchema): Select[T, AliasNames]
infix def fullJoinLateral(query: SelectQuery[_, _]): Select[T, AliasNames]
override def getSelect: SqlSelectQuery
Definition Classes
infix def groupBy(item: Expr[_]*): Select[T, AliasNames]
infix def having(condition: Expr[_]): Select[T, AliasNames]
infix def innerJoin(table: TableSchema[_]): Select[T, AliasNames]
infix def innerJoin(query: SelectQuery[_, _]): Select[T, AliasNames]
infix def innerJoin(table: JoinTableSchema): Select[T, AliasNames]
infix def innerJoinLateral(query: SelectQuery[_, _]): Select[T, AliasNames]
infix def join(table: TableSchema[_]): Select[T, AliasNames]
infix def join(query: SelectQuery[_, _]): Select[T, AliasNames]
infix def join(table: JoinTableSchema): Select[T, AliasNames]
infix def joinLateral(query: SelectQuery[_, _]): Select[T, AliasNames]
infix def leftJoin(table: TableSchema[_]): Select[T, AliasNames]
infix def leftJoin(query: SelectQuery[_, _]): Select[T, AliasNames]
infix def leftJoin(table: JoinTableSchema): Select[T, AliasNames]
infix def leftJoinLateral(query: SelectQuery[_, _]): Select[T, AliasNames]
infix def limit(count: Int): Select[T, AliasNames]
infix def offset(offset: Int): Select[T, AliasNames]
infix def on(onCondition: Expr[_]): Select[T, AliasNames]
infix def orderBy(item: OrderBy*): Select[T, AliasNames]
def pageSql(pageSize: Int, pageNumber: Int)(db: DB): String
infix def rightJoin(table: TableSchema[_]): Select[T, AliasNames]
infix def rightJoin(query: SelectQuery[_, _]): Select[T, AliasNames]
infix def rightJoin(table: JoinTableSchema): Select[T, AliasNames]
infix def rightJoinLateral(query: SelectQuery[_, _]): Select[T, AliasNames]
infix def select[U <: Tuple](items: U): Select[Concat[T, RecursiveInverseMap[U]], Concat[AliasNames, ExtractAliasNames[U]]]
infix def select[I <: SqlDataType](item: Expr[I]): Select[Concat[T, (I)], AliasNames]
infix def select[I <: SqlDataType, N <: String](item: AliasExpr[I, N]): Select[Concat[T, (I)], Concat[AliasNames, (N)]]
infix def select[P <: Product](table: TableSchema[P]): Select[Concat[T, (P)], AliasNames]
override def sql(db: DB): String
Definition Classes
def toCountSql(using db: DB): String
def toPageSql(pageSize: Int, pageNumber: Int)(using db: DB): String
override def toSql(using db: DB): String
Definition Classes
infix def where(condition: Expr[_]): Select[T, AliasNames]
def where(test: () => Boolean, condition: Expr[_]): Select[T, AliasNames]
def where(test: Boolean, condition: Expr[_]): Select[T, AliasNames]

Inherited methods

infix def as(name: String)(using NonEmpty[name.type] =:= Any): SelectQuery[T, AliasNames]
Inherited from:
SelectQuery
infix def except(list: List[T]): UnionSelect[T, AliasNames]
Inherited from:
SelectQuery
infix def except(tuple: T): UnionSelect[T, AliasNames]
Inherited from:
SelectQuery
infix def except[U <: Tuple](select: SelectQuery[U, _]): UnionSelect[Union[T, U], AliasNames]
Inherited from:
SelectQuery
infix def exceptAll(list: List[T]): UnionSelect[T, AliasNames]
Inherited from:
SelectQuery
infix def exceptAll(tuple: T): UnionSelect[T, AliasNames]
Inherited from:
SelectQuery
infix def exceptAll[U <: Tuple](select: SelectQuery[U, _]): UnionSelect[Union[T, U], AliasNames]
Inherited from:
SelectQuery
infix def intersect(list: List[T]): UnionSelect[T, AliasNames]
Inherited from:
SelectQuery
infix def intersect(tuple: T): UnionSelect[T, AliasNames]
Inherited from:
SelectQuery
infix def intersect[U <: Tuple](select: SelectQuery[U, _]): UnionSelect[Union[T, U], AliasNames]
Inherited from:
SelectQuery
infix def intersectAll(list: List[T]): UnionSelect[T, AliasNames]
Inherited from:
SelectQuery
infix def intersectAll(tuple: T): UnionSelect[T, AliasNames]
Inherited from:
SelectQuery
infix def intersectAll[U <: Tuple](select: SelectQuery[U, _]): UnionSelect[Union[T, U], AliasNames]
Inherited from:
SelectQuery
transparent inline def selectDynamic(inline name: String): ColumnExpr[FindTypeByName[Zip[T, AliasNames], Size[T] - 1, name.type] & SqlDataType]
Inherited from:
SelectQuery
infix def union(list: List[T]): UnionSelect[T, AliasNames]
Inherited from:
SelectQuery
infix def union(tuple: T): UnionSelect[T, AliasNames]
Inherited from:
SelectQuery
infix def union[U <: Tuple](select: SelectQuery[U, _]): UnionSelect[Union[T, U], AliasNames]
Inherited from:
SelectQuery
infix def unionAll(list: List[T]): UnionSelect[T, AliasNames]
Inherited from:
SelectQuery
infix def unionAll(tuple: T): UnionSelect[T, AliasNames]
Inherited from:
SelectQuery
infix def unionAll[U <: Tuple](select: SelectQuery[U, _]): UnionSelect[Union[T, U], AliasNames]
Inherited from:
SelectQuery
infix def unsafeAs(name: String): SelectQuery[T, AliasNames]
Inherited from:
SelectQuery

Inherited fields

var aliasName: Option[String]
Inherited from:
SelectQuery