Exactly. Especially around UPDATE [0] and MERGE [1]. A lot of "data engineering" complexity and data pipelines are necessary because of the lack of more-than-

Exactly. Especially around UPDATE [0] and MERGE [1]. A lot of "data engineering" complexity and data pipelines are necessary because of the lack of more-than-superficial knowledge of SQL. Inexperienced developers talk about DAGs of execution and whatnot, without ever realizing they describe atomic (ACID) operations an RDBMS can do out of the box. [0] https://www.postgresql.org/docs/16/sql-update.html https://www.postgresql.org/docs/16/sql-update.html [1] https://www.postgresql.org/docs/16/sql-merge.html https://www.postgresql.org/docs/16/sql-merge.html