In fact, the top one, is a major problem of sql, a blob of char sequence.
The bottom syntax, has syntactic structure that corresponds to semantics.
The bottom has syntactic strecture, cuz for example, first, there's the dot that separate clauses.
Each clause means one single thing.
And, in each clause, u have a function name, or maybe call it a verb, that indicates the primary purpose.
The top one, there's no such syntactic structue.
It's just a sequence of words abc def ghi jil mqr etc.
U have to instead, use semantic meaning of the words, to discern structure.
For example in
from … in … group …
U have to know, from, in, group, are keywords.
And, the word from has a syntactic structure, used together with the in keyword, with grammar from … in …
And the next keyword group, also terminates the above.
Basically, it's like english and other natural human langs.
You do not have syntactic markers.
While the bottom syntax, has syntactic markers that clearly separate clauses, and indicate functions.
For example, the bottom once, once u separate by dot to have clauses, then, the first word, is always the function word.
And is followed by paren, which are arguments. Roughly.
The top one, also have complex grammar.
e.g. Each keyword or set of keyword, has a particular grammar, to themselfs. Not applicable to other keywords.
e.g. from … In …
group … by … into … (3 keywords here, as a grammatical unit)
then
orderby … (1 single keyword here now)
and worst is:
select new {…}
here the last one, with select, it's worst, because now u have seems 2 keywords, but combined in this specific way to from a new phrase which has a very specific meaning, then, it must be followed somehow by braces.
of course, they do the same.
but the main point here, is syntactic structure.
the bottom one has, and the top one does not.
the top one relies on ad hoc grammar for almost every keyword.
while the bottom one, is more systematic.
of course, the bottom one has more code and delimiters like paren, comma, arrow, etc.
but that's minor detail, and can be fixed by diff design.
e.g. what i were saying about linearization of syntax.
