SQLite Forum

SELECT * Column Sequence / Order (not ORDER BY)
So I saw that in a post from section 7.9 3b of that standard.  What I couldn't find was 1) where SQLite promises to meet that standard and 2) how to have SQLite tell me the ordinal position of the columns as part of the table definition.

Either way, it seems SELECT * is generally bad practice for at least the reason you mention about a programmatic change to the column order (which I don't have but over time you never know).