TL;DR: nested WITH statements are supported in all modern data warehouses, lakehouses, and database engines except for Fabric & T-SQL products. This makes the usage of SQL templating engines unneces...
Thanks for your feedback. We are working on adding the support of nested CTE to Fabric Warehousing.
