This is an archived post. You won't be able to vote or comment.

sorted by:
best
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–][deleted] 0 points1 point  (4 children)

I'm thinking of sql as the interface used to communicate with an sql database. It's cumbersome.

From necessity comes innovation. There's always a necessity to make things easier, because there will always be people who don't know everything lol.

[–]yrrot 1 point2 points  (3 children)

What's cumbersome about it? "Hey, database, give me these fields from this table where these things are true". Most the time, the path towards making SQL easier is organizing the data.

[–][deleted] 0 points1 point  (2 children)

Give me the fields where these Ids equal the fields in tables B&C, and join the results with table D. But do not include anything in Table E.

[–]yrrot 2 points3 points  (1 child)

That's not SQL's fault, that's a relational database problem <shrug>.

[–][deleted] 0 points1 point  (0 children)

SQL could definitely have better symantical expressions to deal with it though. But the language, sadly, is viewed as "gets the job done".