MERGE INTO compares source and target rows using a matching condition. It can update matched rows and insert only rows satisfying WHEN NOT MATCHED, making it suitable for idempotent upserts and deduplication. INSERT and APPEND blindly add rows.