3 ms·
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
by gunshai 5y 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.
- Maxion 5y agoTo 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.