SQLite Forum

Ability to: SELECT * EXCEPT(some,columns)
Login
Is there any plan to add the feature of selecting all columns *except* certain ones?

Google's BigQuery has this feature and it's supremely handy at times when you want to grab dozens or hundreds of columns from a large table while excluding only a handful. Otherwise you'd have to explicitly write out all the columns.

Example:

```
-- Select all columns except "COLUMN_ONE"
SELECT * EXCEPT(COLUMN_ONE)
FROM SOME_TABLE
```