Coalesce recommends the use of pipelines vs. Common Table Expressions, or CTEs, for building complex processing with SQL in an analytical environment.
The differences in the CTE vs. pipelines approaches, a contextual example comparing the two, and details on why Coalesce recommends the pipeline approach vs. the CTE approach can be found in our article, CTEs vs Pipelines for Complex Data Processing.
CTEs can be used in Coalesce, however, should you have a use case that requires them. The video below showcases how to leverage CTEs within your Coalesce data projects. Note, however, that Coalesce's recommended approach is the pipelines approach vs. the CTE approach if it works for your use case.