Using MERGE for Upserts

MERGE combines INSERT and UPDATE operations to handle conflicts during data upserts.

MERGE INTO customers AS target
USING incoming_data AS source
ON target.id = source.id
WHEN MATCHED THEN UPDATE SET name = source.name
WHEN NOT MATCHED THEN INSERT (id, name) VALUES (source.id, source.name);