An intersting behavior on SQLite database. Even if the table doesn't have the column, it will be just ignored when it's surrouned by quotes(").
sqlite> select * from t order by `order`; Error: in prepare, no such column: order (1) sqlite> select * from t order by "order"; -- no error! 1|foo 2|bar :
Conclusion: Avoid using reserved words such as
order as the column name.