SQLite Forum

select * from t; -- but don't want virtual columns
Is that not a bad example Simon? Why would you have to change the 'select *'?

Suppose you had a backup for a table with 50 columns 
insert into bkup select * from tbl where ....;
would surely be easier to maintain than the alternative. It would save having to change the backup sql every time you decided to restructure the tables.