SQL is not copy-paste portable.
Each database vendor implements SQL differently.
You can use
joinMonster's options argument to pick your dialect (see details).
Here is a list of the currently supported SQL dialects.
||Application-layer only||Supports the most basic features. Because it's so simple, some other vendors will still work. Postgres and Oracle can, albeit without the pagination features.|
||Offset and keyset with batching only||A more capable superset of MySQL. Version >= 10.2 is required since window functions are used for pagination. If using a prior version, use the MySQL dialect.|
||Application-layer only||Basically the same as SQLite3 but with backticks.|
||All types supported||Fully-featured dialect. Version >= 9.3 required since
||All types supported||Fully-featured dialect. Version >= 12 required since
Adding other dialects is welcomed and encouraged.
Have a look at the