> I would like to make a, perhaps extreme, proposal.

> Since we already support "CREATE OR ALTER ..."

> Why don't we use "INSERT OR UPDATE ..." for the new
> 'replace' functionality?

This gets my vote (since MERGE is apparently not available).
It is clear about what it does, and does not introduce yet
more keywords into the vocabulary.


PS. I think that REPLACE is the correct word for the behaviour
in MySQL - and would be the incorrect word for what you want to
achieve. Replace does imply removal of the existing, or the
restoration of something previously removed.

--
Geoff Worboys
Telesis Computing