It's possible (but maybe not) that this was prompted by my comment a week ago: https://news.ycombinator.com/item?id=9541362 https://news.ycombinator.com/item?i

It's possible (but maybe not) that this was prompted by my comment a week ago: https://news.ycombinator.com/item?id=9541362 https://news.ycombinator.com/item?id=9541362 MERGE is ANSI standard SQL, and so far as I know it's the only upsert-like syntax supported by both Oracle and MS SQL. (Please correct me if I'm wrong.) Even if the MERGE command isn't what we're looking for, we really should make an effort to come up with something that can be implemented in a uniform way across databases. Let's consider whether to use the MySQL syntax (http://dev.mysql.com/doc/refman/5.6/en/insert-on-duplicate.html http://dev.mysql.com/doc/refman/5.6/en/insert-on-duplicate.h...) instead of inventing something new.