SQLite Forum

select * from t; -- but don't want virtual columns
Except for a few unusual cases, I agree that select * should be forbidden in production code, but it is extremely useful for interactively exploring data, debugging, reverse-engineering etc.  And, I’ve often wished for a way to select all columns except for one or two.  In the past, I’ve created scripts that generate a list of all the columns in a table or view (from the data dictionary) that I can quickly edit to make the query I want.  But, that slows me down.