OptionalassignmentsAssignment expressions for tuple, field, or subscript targets, in source order.
Used instead of set when any target needs a structured expression.
Additional tables for multi-table UPDATE (MySQL syntax)
Whether FROM clause appears before SET (Snowflake syntax)
JOINs after FROM clause (PostgreSQL, Snowflake, SQL Server syntax)
Leading comments before the statement
LIMIT clause (MySQL)
Optionalon_ClickHouse distributed lightweight update.
ORDER BY clause (MySQL)
OUTPUT clause (TSQL)
RETURNING clause (PostgreSQL, SQLite)
JOINs attached to the table list (MySQL multi-table syntax)
WITH clause (CTEs)
UPDATE statement