Use a different SQL formatter

[dullbananas]

The horrific formatting of this file is forced by the formatter that's currently used

https://github.com/dullbananas/lemmy/blob/bliss/replaceable_schema.sql

[Nutomic]

Any suggestions? You could also try adjusting the configuration of pg_format.

[dessalines]

I remember trying this prettier plugin for SQL, but I don't think it worked as well.

[dullbananas]

Doesn't format function bodies:

• sqlformat from the sqlparse python package
• prettier-plugin-sql

Not fully implemented yet; throws syntax error:

• prettier-plugin-sql-cst

[phiresky]

The link to the query above no longer works so I can't see exactly what you mean. But last time I investigated SQL formatters, the one we use now was the best there was. I checked the prettier plugin as well but it didn't work.

In a different project, what I did was add a filter if the file starts with -- pgFormatter-ignore it is skipped and not formatted. That "fixed" the few cases where pgformatter was annoying.

[Nutomic]

Feel free to open a PR for this.