Polyglot SQL API Documentation - v0.1.0
    Preparing search index...

    Type Alias Update

    UPDATE statement

    type Update = {
        extra_tables: TableRef[];
        from_before_set: boolean;
        from_clause: From | null;
        from_joins: Join[];
        leading_comments: string[];
        limit: Expression | null;
        order_by: OrderBy | null;
        output: OutputClause | null;
        returning: Expression[];
        set: [Identifier, Expression][];
        table: TableRef;
        table_joins: Join[];
        where_clause: Where | null;
        with: With | null;
    }
    Index

    Properties

    extra_tables from_before_set from_clause from_joins leading_comments limit order_by output returning set table table_joins where_clause with

    Properties

    extra_tables: TableRef[]

    Additional tables for multi-table UPDATE (MySQL syntax)

    from_before_set: boolean

    Whether FROM clause appears before SET (Snowflake syntax)

    from_clause: From | null
    from_joins: Join[]

    JOINs after FROM clause (PostgreSQL, Snowflake, SQL Server syntax)

    leading_comments: string[]

    Leading comments before the statement

    limit: Expression | null

    LIMIT clause (MySQL)

    order_by: OrderBy | null

    ORDER BY clause (MySQL)

    output: OutputClause | null

    OUTPUT clause (TSQL)

    returning: Expression[]

    RETURNING clause (PostgreSQL, SQLite)

    set: [Identifier, Expression][]
    table: TableRef
    table_joins: Join[]

    JOINs attached to the table list (MySQL multi-table syntax)

    where_clause: Where | null
    with: With | null

    WITH clause (CTEs)

    Settings

    Member Visibility

    On This Page

    Properties