Supported Dialects
SQL is not copy-paste portable. Each database vendor implements SQL differently. Here is a list of the currently supported SQL dialects.
"standard"
- No particular dialect. Resorts to very basic features. Should work with SQLite and PostgreSQL, but not MySQL."mysql"
- Specialized for MySQL and MariaDB."pg"
- Specialized for PostgreSQL. Has more advanced pagination thanks to theLATERAL
keyword. This requires version 9.3 or later. This should theoretically work with Oracle, but this is not yet tested.
Adding other dialects is welcome and encourage. Microsoft SQL Server, for example, simply uses CROSS APPLY
instead of LATERAL
. This should be an easy conversion.