sqruff lsp with helix editor

[dionysiusmarquis]

Hey,

I tried to use sqruff lsp with helix:

# .helix/languages.toml

[language-server.sqruff]
command = "sqruff"
args = ["lsp"]

[[language]]
name = "sql"
language-servers = ["sqruff"]

The problem is that the output from the lsp does not match the output of sqruff lint:

• Linting runs without errors or warning but the lsp marks several lines with warning like Expected single whitespace between ")" and ";", Line should not be indented. etc.
• All warnings and errors found by sqruff lint aren't marked via lsp.

I also tried to provide the config file via --config but that didn't change the output of the lsp.

Is there anything i'm missing?

[dionysiusmarquis]

I found what I was missing:

[[language]]
name = "sql"
language-servers = ["sqruff"]
+ roots = [".sqruff"]

seems to be running now.