Should FROM FROM be before SELECT in Sql?

Question

This is what has always bothered me. Wouldn't it make sense to have a FROM clause before a SELECT? Whenever I write sql, especially with joins, I always evaluate the FROM clause and then write SELECT.

Plus, adding FROM first will improve intellisense inside the editor.

Does anyone know what should have been done to make SELECT come first? Am I the only one who cares?

Answer 1

Yes, it is strange and contradictory. Hugh Darwen discusses how this situation happened:

SELECT-FROM-WHERE , , , System R - , , , ...?

, 1960- ( ) , . Terminal Business System (TBS), IBM 1969-77 . , , ...

, IBM , , (, IBM ) ()... SQL, " ! ? , ! , . , , - System R . - . , SQL SELECT-FROM-WHERE .

HAVING

Answer 2

.