QueryAlias

class QueryAlias(val query: AbstractQuery<*>, val alias: String) : ColumnSet

Represents a temporary SQL identifier, alias, for a query.

Constructors

Link copied to clipboard
constructor(query: AbstractQuery<*>, alias: String)

Properties

Link copied to clipboard
Link copied to clipboard
open override val columns: List<Column<*>>

Returns the columns of this column set.

Link copied to clipboard
open override val fields: List<Expression<*>>

Returns the field of this field set.

Link copied to clipboard
Link copied to clipboard
open val realFields: List<Expression<*>>

Returns all real fields, unrolling composite CompositeColumn if present

Link copied to clipboard
open override val source: ColumnSet

Return the column set that contains this field set.

Functions

Link copied to clipboard
open infix override fun crossJoin(otherTable: ColumnSet): Join

Creates a cross join relation with otherTable.

Link copied to clipboard
open override fun describe(s: Transaction, queryBuilder: QueryBuilder)

Appends the SQL representation of this column set to the specified queryBuilder.

Link copied to clipboard
open infix override fun fullJoin(otherTable: ColumnSet): Join

Creates a full outer join relation with otherTable.

Link copied to clipboard
operator fun <T> get(original: Column<T>): Column<T>
operator fun <T> get(original: Expression<T>): Expression<T>
Link copied to clipboard
open infix override fun innerJoin(otherTable: ColumnSet): Join

Creates an inner join relation with otherTable.

Link copied to clipboard
open override fun join(otherTable: ColumnSet, joinType: JoinType, onColumn: Expression<*>?, otherColumn: Expression<*>?, lateral: Boolean, additionalConstraint: SqlExpressionBuilder.() -> Op<Boolean>?): Join

Creates a join relation with otherTable. When all joining options are absent Exposed will try to resolve referencing columns by itself.

Link copied to clipboard
open infix override fun leftJoin(otherTable: ColumnSet): Join

Creates a left outer join relation with otherTable.

Link copied to clipboard
open infix override fun rightJoin(otherTable: ColumnSet): Join

Creates a right outer join relation with otherTable.

Link copied to clipboard
fun select(columns: List<Expression<*>>): Query

Creates a SELECT Query using a list of columns or expressions from this ColumnSet.

fun select(column: Expression<*>, vararg columns: Expression<*>): Query

Creates a SELECT Query by selecting either a single column, or a subset of columns, from this ColumnSet.

Link copied to clipboard
Link copied to clipboard

Creates a SELECT Query by selecting all columns from this ColumnSet.

Link copied to clipboard
Link copied to clipboard
Link copied to clipboard
fun slice(columns: List<Expression<*>>): FieldSet
fun slice(column: Expression<*>, vararg columns: Expression<*>): FieldSet
Link copied to clipboard

Returns the list of tables to which the columns in this column set belong.