sql-formatter-org/sql-formatter v4.0.0

on GitHub

Breaking changes:

• Standard SQL formatter ("sql") now only supports standard SQL. This means:
  • single-quotes for strings and double-quotes for identifiers and no other quote types;
  • only ? placeholders for parameters;
  • only standard SQL operators;
  • only standard SQL sql -- and /* */ comments,
  • if you used language: "sql" before, you're likely better off switching to language: "postgresql" | "mariadb" | "mysql" | "tsql".
• Dropped -f / --file option from CLI. Instead a positional file argument can be used, like with any normal UNIX tool).
• Default export no more exists. Only named export of format function (and supportedDialects - used by CLI).
• Removed FORMATTERS export.
• "pl/sql" alias has been removed. Use "plsql" instead.

New dialects:

• PostgreSQL support
• MariaDB support
• MySQL support
• Transact-SQL support

Fixes:

• Proper formatting of BETWEEN _ AND _
• Bunch of additional operators supported
• No more mixing UNIX and Windows line endings - output is always converted to UNIX LF line endings.

Internal:

• Better whitespace handling without having a separate whitespace token.
• Upgrade to argparse 2.0
• Lots of refactoring and reorganization of tests.