Insert, if unique constraint violation then update; or update, if not found then insert.
Darren Duncan commented
Either use the SQL standard syntax or invent something superior please, rather than say copying a proprietary syntax of some other DBMS.
100% must have.
Yaroslav Potapov commented
This is really need.
Very important thing. Its inconvenient to write those insert-update loops all time.
Ilya Skorik commented
The most tasty thing for me. Which you promise to make many years