It&#x27;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).<p>[0]: <a href="https:&#x2F;&#x2F;wiki.postgresql.org&#x2F;wiki&#x2F;Todo#Optimizer_.2F_Executor" rel="nofollow">https:&#x2F;&#x2F;wiki.postgresql.org&#x2F;wiki&#x2F;Todo#Optimizer_.2F_Executor</a>.
 Search for CTE.