That's how I saw it too, much closer to set theory and relational algebra.

Besides... when I write SQL I write it thus:

SELECT * FROM BLAH

Then refine to:

SELECT * FROM BLAH WHERE FOO

Before finally adding:

SELECT COL1, COL2 FROM BLAH WHERE FOO

Linq matches the way I construct SQL by putting it into the order I logically think of it:

FROM BLAH WHERE FOO SELECT COL1, COL2