Install

Get the latest version from NPM/Yarn:

npm install fmt-sql
#
yarn add fmt-sql

Usage

import sqlFormatter from 'fmt-sql';

console.log(sqlFormatter.format('SELECT * FROM table1'));

Will output:

SELECT *
FROM table1

You 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 | (2 spaces) | | 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 | |