"The syntax is meant to resemble English", obviously.
The link to https://www.lib.umn.edu/collections/special?id=291 is dead, though?
The link to https://www.lib.umn.edu/collections/special?id=291 is dead, though?
The first is much more naturally spoken.
"Saca las manzanas verdes del refrigerador"
Seems like the first example, vs:
"Del refrigerador, saca las manzanas verdes"
That sounds a bit stilted to me.
Green apples, from the refrigerator, select.
In contrast, the father of SQL, Alpha, allowed: "From the refrigerator, select the green apples, insert more milk, and remove any expired items."
A simple way to demonstrate this is how we ended up with cities that have massively different pronunciation even though the spelling is similar.
Most of these arguments that it should work some way logical to the DB make too many assumptions about how the internals of the database work and don't think about how the query optimizer/planner might work very differently than the way a query is organized.
SQL is really old now, 50+ years, assumptions about how it worked or work are probably not that relevant across its entire history.
I first learned it almost 30 years ago now, it was definitely taught back in the day that SQL was one of those odd languages that was designed assuming you "wouldn't need an engineer" to write it. Laughable but would explain why engineers might not find the syntax logical.