Syntax errors are mistakes in the syntax and should (or better not) occur when saving widgets or executing queries.
This is a very common problem, especially from people coming from the SQL world. In DQL, you MUST specify an alternative column name IF it can't be determined automatically. For instance:
draw number using 1 - 2
This is not working, and must be changed like this:
draw number using 1 - 2 as value
The same rules apply to derived tables and sub queries.
All draw queries must start with a “draw something” prefix. If this error occurs, it most likely means the draw prefix is missing. The query might look like this:
using 1 as value
instead of this:
draw number using 1 as value