[jansommer]

CTE's are indeed nice, but can also make your queries substantially slower, at least in Postgres

[DangitBobby]

That's mainly true because you don't have the benefit of an index when you join on a CTE, isn't it?

[jansommer]

It'a slow even without indexes. In other cases, where the CTE is used multiple times in the same query, it can be faster