We hired a data engineering consulting company and none of their team of SQL experts had heard of upsert or merge. I find it weird that people don't spend a bit of time searching for a better way of doing stuff before just jumping into a long, hard way of doing things.
Unfortunately many data engineers don’t know basic stuff about sql snd databases, but are experts in etl tools and data warehouses where such features are not relevant or don’t exist.
You were probably looking for some dba who are something different.
