Ability to disable the formatter for a block of SQL about sql-formatter HOT 2 CLOSED

Implemented in 15.1.0 release.

from sql-formatter.

SQL Formatter is not Prettier. It has not been developed to be compatible with Prettier. Heck, the first version of SQL Formatter was released before Prettier existed.

I know there exists prettier-plugin-sql, which uses SQL Formatter under the hood, but I have no control over that project.

If you're interested in more Prettier-compatible SQL formatting solution, I suggest you try prettier-plugin-sql-cst. This doesn't support the ignore-comments, but there exists more of a chance that such a feature gets implemented.

In this project, the best one could hope for would be a feature where you mark both start and end of the code you don't want to be formatted, like:

/* sql-formatter-disable */
SELECT * FROM tbl
/* sql-formatter-enable */

There could be a point for implementing something like this, as it would help in working around scenarios where the formatter currently fails to produce a sensible output or even crashes. Like:

• #184
• #144

from sql-formatter.