My understanding is that sqruff (and sqlfluff) has similar goals to this project.
Recently I tested sqruff (sqruff-md) for formatting sql queries in clickkouse docs, see related PRs:
It is not perfect (quarylabs/sqruff#1716), but it is usable from cli and in VS Code, see available rules https://github.com/quarylabs/sqruff/blob/main/docs/rules.md
sqruff additionaly supports templaters. I am not sure what is the status of the dbt templater, but it looks like it is a popular request and clickhouse-analyzer should also support dbt in the future.
Also there is some interest from @Blargian to introduce a SQL linter into CI related to clickhouse-docs, see ClickHouse/clickhouse-docs#3995. I guess this should be clickhouse-analyzer or sqruff.
- I just wanted to share that sqruff exists
- Have you previously looked at sqruff?
- What do you think about contributing to sqruff to improve support for clickhouse in sqruff, instead of creating a new project which has similar goals?
My understanding is that sqruff (and sqlfluff) has similar goals to this project.
Recently I tested sqruff (sqruff-md) for formatting sql queries in clickkouse docs, see related PRs:
It is not perfect (quarylabs/sqruff#1716), but it is usable from cli and in VS Code, see available rules https://github.com/quarylabs/sqruff/blob/main/docs/rules.md
sqruff additionaly supports templaters. I am not sure what is the status of the dbt templater, but it looks like it is a popular request and clickhouse-analyzer should also support dbt in the future.
Also there is some interest from @Blargian to introduce a SQL linter into CI related to clickhouse-docs, see ClickHouse/clickhouse-docs#3995. I guess this should be clickhouse-analyzer or sqruff.