Troubleshooting
Database Dialect Problems
Resolve generated or converted SQL that uses syntax from the wrong database system or version.
Steps
1
Confirm the target database
Check the selected database profile and SQL dialect.
2
Identify unsupported syntax
Review functions, date expressions, identifier quoting, pagination, and casts.
3
Use Dialect switcher when appropriate
Convert existing SQL and require the complete revised query, not only an explanation.
4
Validate against the target version
Database versions and compatibility modes can affect supported syntax.