News for hackers. Stuff that matters.

A comment on Shouldn't FROM come before SELECT in SQL? (2011). Parent comment

Re:Shouldn't FROM come before SELECT in SQL? (2011) by mrguyorama on Thursday January 25, 2024 @04:29PM (#39135588)
Alright, I start typing out "SELECT" in my super smart IDE, how does it know which table to suggest columns from?
[ Parent | on HN ]
Re:Shouldn't FROM come before SELECT in SQL? (2011) by randomdata on Thursday January 25, 2024 @04:50PM (#39135867)
Given that it is a very smart IDE, the column suggestion UI integrates table selection in a smart way. Once the IDE knows which table(s) you are referencing, it automatically fills in the FROM clause for you.
[ Parent | on HN ]
Re:Shouldn't FROM come before SELECT in SQL? (2011) by The_Colonel on Friday January 26, 2024 @04:00PM (#39148256)
Looks like my IDE isn't that smart. So I will have to endure the unfriendliness of the SQL towards humans.
[ Parent | on HN ]
Re:Shouldn't FROM come before SELECT in SQL? (2011) by randomdata on Friday January 26, 2024 @05:08PM (#39149294)
Or just use a better language. SQL was designed for non-technical people, using statements that resemble the English they already know. It was not designed for tech-minded people who are able to grasp higher level technical concepts.
[ Parent | on HN ]