SQLite Forum

SELECT * Column Sequence / Order (not ORDER BY)
The virtual table interface explicitly enumerates the columns in definition order and references the columns by number when calling the virtual table's methods. I think SQLite developers would be reluctant to change internal structures because of the extra work that would entail in preserving this documented interface.

The bigger risk for application coders using "*" is the table gets reconstructed with additional fields.