Keyword in sqlite

2022-10-22

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. pos or sort_order?