This is the obvious answer assuming the designer of SQL was a native english speaker. Most of these arguments that it should work some way logical to the DB ma

This is the obvious answer assuming the designer of SQL was a native english speaker. 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.