Postgres 17 mergeInto with returning

[asterikx]

Postgres 17 now supports MERGE INTO with RETURNING (which is very handy to streamline queries and upsert records without writing multiple queries).

MERGE INTO heroes AS h
USING (VALUES ('Wade', 'Wilson', 'Deadpool')) AS v(first_name, last_name, hero_name)
ON h.hero_name = v.hero_name
WHEN MATCHED THEN
  UPDATE SET first_name = v.first_name, last_name = v.last_name
WHEN NOT MATCHED THEN
  INSERT (first_name, last_name, hero_name)
  VALUES (v.first_name, v.last_name, v.hero_name)
RETURNING merge_action(), *;

Is it possible to create the preceding query (taken from the Neon release note) with Kysely?

[igalklebanov]

Hey 👋

Not yet.