The importance, off course, is that you should know, in advance, what it is you are trying to do. Only the business logic knows that in normal scenarios. If not, I think you're UPSERT is a nice allternative.

I myself don't think the concept of UPSERT needs further explanation. The word itself says what it is supposed to do, even the order of things to happen are OK.

Good article, keep them coming