The SQL query shown in the Query Builder is not the actual query used on the server, it is only there as a preview. The query is using the ANSI SQL standard, your database could require other escaping or functions could be named different. mySQL uses the backtick ` for escaping while MS SQL Server uses [] and in the ANSI SQL standard it is ". The actual used query is generated on the server.
1 Like