Supported Databases

Automatic Detection

SQL dialect is automatically detected from your JDBC connection. No manual configuration needed.

PostgreSQL (9.6+)

Features:

• Full support for all query types
• CTE (WITH) support
• ILIKE for case-insensitive matching
• Advanced data types (JSON, JSONB, arrays, UUID)

Dialect optimizations:

• LIMIT/OFFSET for pagination
• NULLS FIRST/LAST for sort ordering

MySQL (5.7+)

Features:

• Full support for all query types
• CTE support (MySQL 8.0+)

Dialect optimizations:

• LIMIT offset, count pagination
• Backtick identifier quoting

SQL Server (2016+)

Features:

• Full support for all query types
• CTE support
• Window functions

Dialect optimizations:

• OFFSET/FETCH pagination
• Square bracket identifier quoting
• TOP clause support

Oracle (11g+)

Features:

• Full support for all query types
• CTE support
• Window functions

Dialect optimizations:

• ROWNUM or FETCH FIRST pagination
• Double-quote identifier escaping

Snowflake

Features:

• Full support for all query types
• CTE support
• Window functions

Google BigQuery

Features:

• Full support for all query types
• CTE support
• Window functions

Amazon Redshift

Features:

• Full support for all query types
• CTE support
• Window functions

ANSI SQL (Fallback)

For databases not explicitly supported, the library falls back to ANSI SQL standard dialect.