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

[1] https://www.postgresql.org/docs/16/sql-merge.html