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-...