fmt-sql

With the help of @ sqltools/formatter, it is reformed

Usage no npm install needed!

<script type="module">
  import fmtSql from 'https://cdn.skypack.dev/fmt-sql';
</script>

README

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