Basically true except for many implementations of MERGE not being concurrency safe, which means you would have to loop anyway on unique violation making it no b

Basically true except for many implementations of MERGE not being concurrency safe, which means you would have to loop anyway on unique violation making it no better than the CTE based techniques that already exist in 9.4.