Comment by gunshai
4 years ago
My brain just thinks in CTEs over sub queries. I really dislike that my co-workers use these ridiculously nested sub sub sub queries.
I just look at something like this and I immediately know what's going on. If it's nested sub queries it always takes me much longer.
To me those nested sub sub sub SQL queries come from a similar place as beginner coders who tend to make nested IF statements - a lack of experience with the language.
For very complicated stuff, SQL does become very hard to read compared to e.g. tidyverse + targets in R.