- The SQL dialect option appears when adding a query to datasources such as RDBMS. For example,
- Click Add New SQL Dialect to open the SQL Dialect window. Select the required SQL driver and define the SQL statement as shown below.
If the SQL statement should be the same for multiple drivers, select all drivers (e.g., MySQL, PostgreSQL and H2) at once and define the statement as shown below.
To define an SQL dialect for a driver other than the ones listed in the supported drivers list, provide the driver prefix in the text field and define the SQL query as shown above.