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 the
LATERALkeyword. 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.