Common Table Expressions in SQL are a code smell

Oct. 4, 2017 by

I’ve recently come to the conclusion that Common Table Expressions (CTE) in SQL are almost always undesirable.  CTE’s are a powerful feature.  But unless they’re recursive, CTE’s are just replacements