Entity
    Preparing search index...

    Variable SQLFragmentHelpersConst

    SQLFragmentHelpers: {
        and(...conditions: SQLFragment[]): SQLFragment;
        between<T extends string | number | Date>(
            column: string,
            min: T,
            max: T,
        ): SQLFragment;
        eq(column: string, value: SupportedSQLValue): SQLFragment;
        group(condition: SQLFragment): SQLFragment;
        gt(column: string, value: SupportedSQLValue): SQLFragment;
        gte(column: string, value: SupportedSQLValue): SQLFragment;
        ilike(column: string, pattern: string): SQLFragment;
        inArray<T extends SupportedSQLValue>(
            column: string,
            values: readonly T[],
        ): SQLFragment;
        isNotNull(column: string): SQLFragment;
        isNull(column: string): SQLFragment;
        jsonContainedBy(column: string, value: unknown): SQLFragment;
        jsonContains(column: string, value: unknown): SQLFragment;
        jsonPath(column: string, path: string): SQLFragment;
        jsonPathText(column: string, path: string): SQLFragment;
        like(column: string, pattern: string): SQLFragment;
        lt(column: string, value: SupportedSQLValue): SQLFragment;
        lte(column: string, value: SupportedSQLValue): SQLFragment;
        neq(column: string, value: SupportedSQLValue): SQLFragment;
        not(condition: SQLFragment): SQLFragment;
        notBetween<T extends string | number | Date>(
            column: string,
            min: T,
            max: T,
        ): SQLFragment;
        notIlike(column: string, pattern: string): SQLFragment;
        notInArray<T extends SupportedSQLValue>(
            column: string,
            values: readonly T[],
        ): SQLFragment;
        notLike(column: string, pattern: string): SQLFragment;
        or(...conditions: SQLFragment[]): SQLFragment;
    } = ...

    Common SQL helper functions for building queries

    Type Declaration

    Settings

    Member Visibility