SQLite Forum

Feature Request: pragma to curb bad column expectations
This would be non-compliant with the standard.  The standard requires that if a "returned column" refers to table column and is unambiguous, that the returned name, unless overridden by an AS clause, be the bare column name.

So you would be free to shuffle-about the column ordering or the names of computed columns, but bare columns must be named with the bare column name (where that name is unambiguous).