INSERT ... ON CONFLICT has fewer surprises in context of concurrency: https://modern-sql.com/caniuse/merge#illogical-errors https://modern-sql.com/caniuse/merge

INSERT ... ON CONFLICT has fewer surprises in context of concurrency: https://modern-sql.com/caniuse/merge#illogical-errors https://modern-sql.com/caniuse/merge#illogical-errors Besides portability, there is IMHO nothing against INSERT ... ON CONFLICT if it does what you need.