But the syntax is in the wrong order for autocomplete to help you.
If from was first, autocomplete could help you with the names of columns, like RStudio does with dplyr:
data_frame_name %>% select(column_name)
Because you start by piping the data reference into your select function, RStudio can inspect the data and autocomplete the column names in the select statement, completely opposite of what is possible inSQL
With a free order, you'd be able to start SQL queries with `FROM table_name SELECT ...` and have columns autocompleted.
Sorry, I didn't mean that in defense of SELECT being first. I agree with the article that SELECT must come toward the end. And the first thing I tell people I teach SQL to is that they have to read SELECT last.
If from was first, autocomplete could help you with the names of columns, like RStudio does with dplyr:
Because you start by piping the data reference into your select function, RStudio can inspect the data and autocomplete the column names in the select statement, completely opposite of what is possible inSQLWith a free order, you'd be able to start SQL queries with `FROM table_name SELECT ...` and have columns autocompleted.