FYI one method is to use CTEs (WITH) to force Postgres via materialization. https://www.postgresql.org/docs/current/queries-with.html https://www.postgresql.or

FYI one method is to use CTEs (WITH) to force Postgres via materialization. https://www.postgresql.org/docs/current/queries-with.html https://www.postgresql.org/docs/current/queries-with.html