Member Junction
    Preparing search index...

    Interface DialectWriter

    Writes SQL fragments in a dialect's syntax: quoting, literals, row caps and the common expressions whose spelling differs between databases.

    interface DialectWriter {
        NullLiteral: string;
        BooleanLiteral(value: boolean): string;
        Cast(expr: string, sqlType: string): string;
        CastToText(expr: string): string;
        Coalesce(expr: string, fallback: string): string;
        Concat(...parts: string[]): string;
        ConcatOperator(): string | null;
        CurrentTimestampUTC(): string;
        DateAddExpression(
            unit: DateAddUnit,
            amount: number,
            baseExpr: string,
        ): string;
        EscapeLikePattern(text: string): string;
        IIF(condition: string, trueVal: string, falseVal: string): string;
        IsNull(expr: string, fallback: string): string;
        JsonExtract(column: string, path: string): string;
        LimitClause(limit: number, offset?: number): LimitClauseResult;
        LowerCase(expr: string): string;
        QuoteColumnAlias(aliasName: string): string;
        QuoteIdentifier(name: string): string;
        QuoteSchema(schema: string, object: string): string;
        QuoteStringLiteral(value: string): string;
        StringLiteralPrefix(text: string): string;
    }

    Implemented by

    Index

    Properties

    NullLiteral

    Methods

    BooleanLiteral Cast CastToText Coalesce Concat ConcatOperator CurrentTimestampUTC DateAddExpression EscapeLikePattern IIF IsNull JsonExtract LimitClause LowerCase QuoteColumnAlias QuoteIdentifier QuoteSchema QuoteStringLiteral StringLiteralPrefix

    Properties

    NullLiteral: string

    The NULL literal.

    Methods

    Settings

    Member Visibility

    On This Page

    Properties
    Methods