SQLite Forum

Force SELECT * on a virtual table to return a HIDDEN column
Login
Sorry, can't do it.  Apart from the one you rejected here are two alternatives:

1. Don't mark it as HIDDEN
2. Instead of <code>SELECT * FROM file</code> make a VIEW called "filelist".  The VIEW is <code>SELECT *, file_id FROM file</code>.  Use this view instead of the table itself when you want the extra column.