Remarks on ShortSql

ShortSQL tries to return dialect-agnostic SQL, which can be run on the main database engine supported by BraDypUS, SQLite, MySQL/MariaDB and PostgreSQL. This means that:

  • no backticks (`) are used to mark table or column names. In general, table ane column names are not marked;
  • column aliases are marked by double quotes (). This is supported in all the mentioned database engines;
  • offset is clearly stated in limit statement and is never ommitted, whitch is a MySQL-limited feature.


In order to use the ShortSQL string in a query string it must be url-encoded, e.g.:

// javascript
const urisafe = encodeURIComponent(shortSql);


// php
$urisafe = urlencode($shortSql);