Issue with CTEs for MSSql and Azure
Last updated: March 20, 2025
CTEs such as queries that use WITH clauses are not supported for MSSQL and Azure databases in Explo.
This is database specific, so these clauses and certain CTEs can be used for other databases and data warehouses.
The reason this will not work is because Explo wraps all queries that are written in the datasets as subqueries in a larger query that we are generating. For certain database types, using a CTE is supported in subquery, but in others, it will not.