Member Junction
    Preparing search index...

    Interface SQLValidationOptions

    Options for SQL expression validation

    interface SQLValidationOptions {
        additionalAllowed?: string[];
        additionalBlocked?: string[];
        allowSubqueries?: boolean;
        context: SQLValidationContext;
        Dialect?: SQLScreeningDialect;
        entityFields?: string[];
        requireAggregate?: boolean;
    }
    Index

    Properties

    additionalAllowed?: string[]

    Custom allowed keywords/functions to add

    additionalBlocked?: string[]

    Custom blocked keywords to add

    allowSubqueries?: boolean

    Whether to allow SELECT keyword (normally blocked for subquery prevention)

    Validation context affects what's allowed

    The dialect that will run the SQL, which decides how quotes, identifiers and comments are read. Without one, the SQL must pass under every dialect ScanSQLForScreening knows.

    entityFields?: string[]

    Entity field names for validation (optional - enables field checking)

    requireAggregate?: boolean

    Whether to require at least one aggregate function (for 'aggregate' context). Default: true for aggregate context