SQLSelectStatement

classin packageklyn.data.sql.internal

public final class SQLSelectStatement:

SQLSelectStatement

Immutable structured single-table SELECT statement.

command = selectStatement.render(PostgreSQLDialect())

Properties

Modifier and Type	Member	Description
public readonly property	distinct `distinct as Boolean`	No summary.
public readonly property	limit `limit as Long`	No summary.
public readonly property	offset `offset as Long`	No summary.
public readonly property	orders `orders as ArrayList<SQLOrder>`	No summary.
public readonly property	predicate `predicate as SQLExpression`	No summary.
public readonly property	projections `projections as ArrayList<SQLExpression>`	No summary.
public readonly property	schemaName `schemaName as String`	No summary.
public readonly property	tableName `tableName as String`	No summary.

Constructors

Modifier and Type	Member	Description
public	SQLSelectStatement `SQLSelectStatement( tableName as String, schemaName as String, projections as IList<SQLExpression>, predicate as SQLExpression, orders as IList<SQLOrder>, offset as Long, limit as Long, distinct as Boolean ):`	Creates a validated immutable SELECT tree.

Methods

Modifier and Type	Member	Description
public	render `render(dialect as SQLDialect) as SQLCommand:`	Renders one prepared SQL command.
public	renderCount `renderCount(dialect as SQLDialect) as SQLCommand:`	Renders an exact count over this statement's complete result window.
public	renderExists `renderExists(dialect as SQLDialect) as SQLCommand:`	Renders a one-row existence probe without materializing projections.