Hacker News Reader

Actually standard SQL does specify a MERGE command (which lets you implement an upsert) and it's implemented in Postgres

MERGE debuted in PostgreSQL 15 fairly recently, and has some caveats.