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...
The support of nested CTE has been added to Warehouse and SQL Analytics Endpoint in Microsoft Fabric. Please check this article for more details. Nested Common Table Expression (CTE) - SQL Server | Microsoft Learn
