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.

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.