SQLDialect

interfacein packageklyn.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.
public readonly property	supportsFullOuterJoin `supportsFullOuterJoin as Boolean`	Whether this dialect accepts a native `FULL OUTER JOIN`.
public readonly property	supportsRightJoin `supportsRightJoin as Boolean`	Whether this dialect accepts a native `RIGHT JOIN`.

Methods

Modifier and Type	Member	Description
public	concatenate `concatenate(left as String, right as String) as String`	Renders concatenation without embedding application values.
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 for 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	slice `slice(value as String, start as String, length as String = "") as String`	Renders a zero-based Klyn string slice from a normalized start and length.
public	startsWith `startsWith(value as String, prefix as String) as String`	Renders a prefix predicate.