Probably. In Postgres, WITH queries are not "optimizer fences" since version 12 [0]. But I discovered many other usefull features/tips. [0] https://www.depes

Probably. In Postgres, WITH queries are not "optimizer fences" since version 12 [0]. But I discovered many other usefull features/tips. [0] https://www.depesz.com/2019/02/19/waiting-for-postgresql-12-allow-user-control-of-cte-materialization-and-change-the-default-behavior/ https://www.depesz.com/2019/02/19/waiting-for-postgresql-12-...