I'll take actual usefulness in practice any day over theoretical elegantness that has problems in practice.

And really, upserts aren't that hard to understand.