SQL could also have done what they wanted, for example allowing both

  FROM foo
  WHERE baz = quux
  SELECT bar

and even (the equivalent linq wont compile because ‘baz’ isn’t there anymore when the ‘where’ runs)

  FROM foo
  SELECT bar
  WHERE baz = quux

However, SQL predates smart code completion being an expected language feature, so they went for the feature “looks like normal American English” (“from the kitchen, can you get me the scales?” is less common than “can you get me the scales from the kitchen?” or “can you get me the scales? They’re in the kitchen”) instead of “make a grammar where smart code completion works well”.