Duckdb recently added new merge functionality: duckdb/duckdb#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
Duckdb recently added new
mergefunctionality: duckdb/duckdb#18135SQLMesh should update its
mergestrategy to make incrementals more efficient.Design Considerations:
Internal Slack thread: https://tobikodata.slack.com/archives/C04DTU8RF4J/p1752768381864729