SQLDialect
interface in package klyn.data.sql

    public interface SQLDialect:

SQLDialect

Relational dialect contract used to render a structured SQL AST.

Identifiers are always supplied by validated mappings, never by user values. Values are represented by prepared-statement parameter markers.

    dialect as SQLDialect = PostgreSQLDialect()
    print(dialect.quoteIdentifier("users"))

Properties

Modifier and Type | Member | Description
--- | --- | ---
public readonly property | name `name as String` | Stable dialect identifier.

Methods

Modifier and Type | Member | Description
--- | --- | ---
public | concatenate `concatenate(left as String, right as String) as String` | Renders concatenation without embedding application values.
public | contains `contains(value as String, fragment as String) as String` | Renders a substring containment predicate.
public | endsWith `endsWith(value as String, suffix as String) as String` | Renders a suffix predicate.
public | floorDivide `floorDivide(left as String, right as String) as String` | Renders mathematical floor division.
public | length `length(expression as String) as String` | Renders the character length of one SQL expression.
public | paginate `paginate(sql as String, hasOrder as Boolean, offset as Long, limit as Long) as String` | Renders provider-specific pagination after a SELECT statement.
public | parameterMarker `parameterMarker(index as Int) as String` | Returns the prepared-statement marker for a one-based parameter index.
public | power `power(left as String, right as String) as String` | Renders exponentiation.
public | quoteIdentifier `quoteIdentifier(identifier as String) as String` | Quotes one validated identifier.
public | startsWith `startsWith(value as String, prefix as String) as String` | Renders a prefix predicate.
public | substring `substring(value as String, start as String, length as String = "") as String` | Renders a zero-based Klyn substring expression.