SQLite Forum

Ability to: SELECT * EXCEPT(some,columns)
Login
Original poster here. I agree the "range of columns" is probably a nightmare to implement. Also schemas change all the time, even in production-level systems that use SQLite as a database, so a range might be a dangerous way to go.

The `except(columns,listed,here)` method does already exist in some systems (well, BigQuery that I've used) and it's been very handy when needing to exclude certain things like columns with personal info or row_number() values for deduplication.

I see in the commit timeline that the `alter table drop column` functionality is being worked on - so this could be a proxy for the `exclude()` feature by creating the table, then dropping those few columns you want to exclude. 


JW