Control formatting options

[mtaylorfsmb]

Type: Feature Request

Every time I save a query file it auto-formats the SQL file. This is correct because I have this feature set for VSCode. However the formatter for SQL is bad. It basically messes up my queries and I have to undo the changes.

The only workaround right now is to disable auto-format on save for all of VS Code or live with the poorly formatted SQL files. Neither is ideal.

We need to be able to control how SQL files are formatted like we can for other languages. Alternatively we need to be able to turn off this feature on a language by language basis, which is probably a VS Code change.

Right now formatting is just plain bad and this is yet another knock against this extension. I honestly find working in SSMS, with is broken Intellisense, faster and easier than using this extension right now.

Extension version: 1.28.0
VS Code version: Code 1.97.1 (e249dada235c2083c83813bd65b7f4707fb97b76, 2025-02-10T13:13:58.153Z)
OS version: Windows_NT x64 10.0.26100
Modes:

[LarnuUK]

Language specific settings already exist in VSCode. Does adding the following to your settings work?

"[sql]": {
    "editor.formatOnSave": false
}

Note: If you have custom settings for the sql language already, then just add the editor.formatOnSave setting to it.

[mtaylorfsmb]

@LarnuUK Yes it does! Thank you. I didn't know you could disable this on a per-language basis. At least there is this workaround for now until we have control over how SQL formatting works.