Commits on Aug 21, 2026

1. Add support for INSERT ... SET syntax

   This commit adds support for INSERT ... SET syntax, which allows
   specifying column values using named assignments instead of
   requiring a separate column list and VALUES clause.
   Syntax:
       INSERT INTO table_name SET column1=value1, column2=value2, ...;
   This syntax provides a more convenient and readable alternative for
   single-row inserts, particularly when only specific columns need values.
   Columns not mentioned in the SET clause receive their default values or
   NULL, consistent with standard INSERT behavior.
   Features supported:
   - Basic syntax: INSERT INTO t SET col=val, ...
   - DEFAULT keyword: SET col=DEFAULT
   - NULL values: SET col=NULL
   - Expressions and functions: SET col=expr
   - Subqueries: SET col=(SELECT ...)
   - RETURNING clause: SET ... RETURNING *
   - ON CONFLICT: SET ... ON CONFLICT DO UPDATE/NOTHING
   - OVERRIDING SYSTEM VALUE: OVERRIDING SYSTEM VALUE SET ...
   - Multi-row syntax: SET (col1=val1, col2=val2), (col1=val3, col2=val4)
   - Support for different column sets in multi-row inserts

   

   authored and Commitfest Bot committed

   Aug 21, 2026
   Configuration menu

   Browse the repository at this point in the history

2. Configuration menu

   Browse the repository at this point in the history