SQLFluff Clickhouse linter making incorrect changes in lints

[Camyll]

While trying to lint previously existing clickhouse queries with new sqlfluff clickhouse linting, we see erroneous changes made. Need to understand how to remove the rule that causes this

Example is torchci/clickhouse_queries/job_duration_avg/query.sql in this PR draft: https://github.com/pytorch/test-infra/pull/6311/files