@sqltools/formatter

SQL Formatting

This feature allows you to format SQL queries. The code sample demonstrates how to format a simple SQL SELECT query using the package.

const { format } = require('@sqltools/formatter');
const query = 'SELECT * FROM table WHERE id = 1';
const formattedQuery = format(query, { language: 'sql' });
console.log(formattedQuery);

Customizing Formatting Options

This feature allows you to customize the formatting options such as indentation, case, and line breaks. The code sample shows how to format a query with custom options for indentation and uppercase keywords.

const { format } = require('@sqltools/formatter');
const options = {
  language: 'sql',
  indent: '    ',
  uppercase: true
};
const query = 'select * from table where id = 1';
const formattedQuery = format(query, options);
console.log(formattedQuery);