SQL is unintuitive, unintelligible, unreadable. Nested select statements makes you have no idea what you're selecting, ambiguous join methods give you a false sense of security that you're getting the right data, and any data manipulation is impossible. SQL is ass
Things have worked for years. Maybe you are the issue 🙈
This statement is so true that it's applicable everywhere else, i.e: Patriarchy has worked for years so if you desire a change maybe you are the problem 🤦
What's wrong with the patriarchy?
it’s a tool. simple as. you gotta use the right tool for the job.
Much of the time a subquery could be a CTE.
You don't know enough languages to have an opinion
Instead of nested sql, rewrite it as cte, with clause. Much more readable. I write 1000+ lines of sql stmt regularly
What the fuck is cte SQL gives me cte
In my opinion SQL is awesome. The best part about it is that you can make it as complicated as you want or as simple as you want. I prefer creating temp tables and breaking down solution into pieces than trying to do too many things in nested select statements. Joins need knowing the data set and a good quality check mechanism. Even a basic count (*) and count distinct primary key goes a long way than guessing if you did your join right.
SQL is one of the best languages ever written. It’s hard because it makes you think in sets instead of iteratively
Ass Queue El? Or See Quell?
Sequel