UPSERT
is extremely handy, and reduces the number of find, check on server, update loops. But
RETURNING
is a fundamental part of that (to get the updated/existing) ID. Can't believe SQL hasn't standardized it yet as of 2022. But both
SQLite and
Postgres support it with similar syntax thankfully.