Hacker News Reader

Ah, by “join syntax” do you mean like this answer: https://stackoverflow.com/a/70803859 ?

Unnesting is a bit orthogonal, I'm basically saying any UPDATE statement that has a FROM clause in Postgres.