Yeah I agree, most queries can be done without using CTEs, but some problems can hardly be solved without them. I'm thinking e.g. of finding paths in a graph or

Yeah I agree, most queries can be done without using CTEs, but some problems can hardly be solved without them. I'm thinking e.g. of finding paths in a graph or querying highly hierarchical data in an efficient way.