Install

Get the latest version from NPM/Yarn:

1npm install fmt-sql
2#
3yarn add fmt-sql

Usage

1import sqlFormatter from 'fmt-sql';
2
3console.log(sqlFormatter.format('SELECT * FROM table1'));

Will output:

SELECT *
FROM table1

You can also pass in configuration options:

1sqlFormatter.format('SELECT *', {
2  language: 'sql',
3  indent: '\t', // Defaults to two spaces
4});

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