sql-formatter 8.1.0

on Node.js NPM

Bugfixes

• Fix formatting of DESC inside ORDER BY for MariaDB #298
• Fix multiple problems with LIMIT clause formatting #301 #303

Improvements

• No more adding spaces around :: operator.
• Add support for multiple PostgreSQL JSON and other operators #296
• Add support for N1QL operator: ||.
• Add support for DB2 operators: ¬=, ¬>, ¬<.
• Add support for SQLite operators: ->, ->>.
• Add support for ~, #, ?, ! operators in several dialects.

Internals

• Reorganize code in core/ dir into lexer/, parser/, formatter/ directories.
• Major refactoring of Tokenizer.
• Several new token types: DELIMITER, COMMA, IDENTIFIER, QUOTED_IDENTIFIER, NAMED_PARAMETER, QUOTED_PARAMETER, INDEXED_PARAMETER, POSITIONAL_PARAMETER.