Free tool

Upsert / MERGE SQL generator

Every destination spells "insert or update" differently, and most of the differences bite at 3 a.m.: a MERGE that fails on duplicate source rows, an ON CONFLICT with no matching index, a Redshift delete that leaves ghost rows. Pick the destination, name your table, key and columns, and get the statement that is correct there.

The statements come from the load profiles Datrise uses to land CRM entities into each destination, including the watermark guard that stops an older row from overwriting a newer one. Nothing you type leaves the browser; the share link encodes the form in the URL.

INSERT INTO "deals" ("id", "name", "stage", "amount", "owner_id", "updated_at")
SELECT "id", "name", "stage", "amount", "owner_id", "updated_at"
FROM "deals_staging"
ON CONFLICT ("id") DO UPDATE SET
  "name" = EXCLUDED."name",
  "stage" = EXCLUDED."stage",
  "amount" = EXCLUDED."amount",
  "owner_id" = EXCLUDED."owner_id",
  "updated_at" = EXCLUDED."updated_at"
WHERE "deals"."updated_at" IS NULL
   OR "deals"."updated_at" < EXCLUDED."updated_at";