It seems that perhaps the SQL syntax people weren't thinking about code completion (or intellesense) when coming up with the language.
Typing in a SELECT will give you nothing, because you selecting from what? Once you have the FROM tableName statement then you could go back to your select and specify column names but what a pain. Maybe the SQL syntax should have looked like this:
FROM tableName
SELECT columnName, anotherOne
WHERE columnName = 'me'
Maybe the LINQ people saw this issue too so that's why they have it switched? Makes more sense to me. I wonder why no one has thought to switch it around, or have they?