I feel like a lot of the trade-offs forced on you by dsql, you are forced into when scaling Postgres.

Like if I’m an SRE/DBA and you running massive update queries in a single transaction, that is the first thing I’m getting rid of.

I agree, same for foreign keys, triggers, higher isolation levels, the list goes on