SQLite Forum

SELECT * Column Sequence / Order (not ORDER BY)
Login
You should list out all the columns you want in your application code.
The "*" notation is useful when doing ad hoc queries from a command-line
but should be avoided when constructing queries that are baked into
an application because the order of the columns might change and/or
new columns might be added.