Fork from sql-formatter
npm install sql-formatter-unicode
npm install sql-formatter-unicode
`
Usage
`js
import sqlFormatter from "sql-formatter-unicode";
console.log(sqlFormatter.format("SELECT * FROM table1"));
`
This will output:
`
SELECT
*
FROM
table1
`
You can also pass in configuration options:
`js
sqlFormatter.format("SELECT *", {
language: "n1ql", // Defaults to "sql"
indent: " " // Defaults to two spaces
});
`
Currently just four SQL dialects are supported:
- sql - [Standard SQL][]
- n1ql - [Couchbase N1QL][]
- db2 - [IBM DB2][]
- pl/sql - [Oracle PL/SQL][]
$3
`js
// Named placeholders
sqlFormatter.format("SELECT * FROM tbl WHERE foo = @foo", {
params: {foo: "'bar'"}
}));
// Indexed placeholders
sqlFormatter.format("SELECT * FROM tbl WHERE foo = ?", {
params: ["'bar'"]
}));
`
Both result in:
`
SELECT
*
FROM
tbl
WHERE
foo = 'bar'
`
Usage without NPM
If you don't use a module bundler, clone the repository, run npm install and grab a file from /dist directory to use inside a