SQLite Forum

Feature Request: pragma to curb bad column expectations
Login
Dear Devs,

In a recent thread I related the human error of bad expectations regarding column ordering. It's a song I know very well from having to recite it often.

Would it be feasible to add a pragma like "reverse\_unordered\_selects" but perhaps named:
"reverse\_asterisk\_column\_names" 
or perhaps 
"random\_wildcard\_columns" 

I believe the idea is obvious. Perhaps obfuscating both un-aliased column names and unspecified positioning.

I often find contributing programmers who forego the SELECT column request specification, and introducing this pragma will help make these egregious habits visible before production switchover.


And while I'm in the asking chair...
Please note our continued plight for pragma "strict\_mode". :)