About
The whole SQL syntax documentation for SQLite can be found at lang and/or full sql
List
Support
[SQLITE_ERROR] SQL error or missing database (row value misused)
This error may be caused in a group by clause if you group the columns with parentheses.
Example:
group by (col1, col2)
To resolve this issue, you need to suppress the parentheses. Example:
group by col1, col2