SQLite Forum

select * from t; -- but don't want virtual columns
The standard answer on this is that you shouldn't be using <code>SELECT *</code> at all in production code.

That shortcut can be useful in quick scripts and debugging, but has nasty results when used in a program you're not going to look at for years.  The most obvious is that if you come back to an old project and add an extra column to a table, you then have to change every <code>SELECT *</code>.