SQLSelectStatement
class in package klyn.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.