I'm not denying the importance of performance and query planning here, but merging two statements into one is what I as a (specific kind of) data engineer care

I'm not denying the importance of performance and query planning here, but merging two statements into one is what I as a (specific kind of) data engineer care about more. Letting postgres take care of consistency while keeping the SQL readable is just pure value addition.