1.0.3 • Published 4 years ago
fmt-sql v1.0.3
Install
Get the latest version from NPM/Yarn:
npm install fmt-sql
#
yarn add fmt-sqlUsage
import sqlFormatter from 'fmt-sql';
console.log(sqlFormatter.format('SELECT * FROM table1'));Will output:
SELECT *
FROM table1You can also pass in configuration options:
sqlFormatter.format('SELECT *', {
language: 'sql',
indent: '\t', // Defaults to two spaces
});Options
| option | description | type | default |
|---|---|---|---|
| language | Query language, default is Standard SQL | sql, n1ql, db2, pl/sql | sql |
| indent | Characters used for indentation | string | |
| reservedWordCase | How to change the case of reserved words | upper, lower, null | null (no change) |
| linesBetweenQueries | How many line breaks between queries | number or 'preserve' | 1 |
| params | Collection of params for placeholder replacement | object for name params, array for indexed placeholders |