It's planned, apparently. [0] When it was discussed on the mailing list, it sounds like people were in favor of adding a keyword to disable it, making the synta

It's planned, apparently. [0] When it was discussed on the mailing list, it sounds like people were in favor of adding a keyword to disable it, making the syntax something like WITH UNBOXED (subquery) or WITH VIEW (subquery). [0]: https://wiki.postgresql.org/wiki/Todo#Optimizer_.2F_Executor https://wiki.postgresql.org/wiki/Todo#Optimizer_.2F_Executor. Search for CTE.