Duckdb recently added new `merge` functionality: https://github.com/duckdb/duckdb/pull/18135 SQLMesh should update its `merge` strategy to make incrementals more efficient. Design Considerations: - Make sure sqlglot handles it correctly - Switch out which approach DuckDB uses in SQLMesh (easy) - Validate correctness in SQLMesh Internal Slack thread: https://tobikodata.slack.com/archives/C04DTU8RF4J/p1752768381864729
Activity
feat(duckdb): use native MERGE for incremental by unique key models