QuerySource

data class QuerySource(val database: Database, val sourceTable: BaseTable<*>, val expression: QuerySourceExpression)(source)

Represents a query source, used in the from clause of a query.

Since

2.7

Constructors

Link copied to clipboard
constructor(database: Database, sourceTable: BaseTable<*>, expression: QuerySourceExpression)

Properties

Link copied to clipboard

the Database instance that the query is running on.

Link copied to clipboard

the underlying SQL expression.

Link copied to clipboard

the origin source table.

Functions

Link copied to clipboard

Perform a cross join and return a new QuerySource, translated to cross join in SQL.

Link copied to clipboard

Perform a full join and return a new QuerySource, translated to full join in SQL.

Link copied to clipboard

Perform an inner join and return a new QuerySource, translated to inner join in SQL.

Link copied to clipboard

Return a new-created Query object, left joining all the reference tables, and selecting all columns of them.

Link copied to clipboard

Perform a left join and return a new QuerySource, translated to left join in SQL.

Link copied to clipboard

Perform a right join and return a new QuerySource, translated to right join in SQL.

Link copied to clipboard
fun QuerySource.select(vararg columns: ColumnDeclaring<*>): Query

Create a query object, selecting the specific columns or expressions from this QuerySource.

Link copied to clipboard

Create a query object, selecting the specific columns or expressions from this QuerySource distinctly.