How to use different dialects in a mono repo?

[hongbo-miao]

When I use SQLFluff, I can pass different dialects like:

sqlfluff lint --dialect=athena amazon-athena/queries
sqlfluff lint --dialect=bigquery bigquery/queries
sqlfluff lint --dialect=clickhouse clickhouse/queries
sqlfluff lint --dialect=postgres postgres/queries

For sqruff, I saw

sqruff lint --help

Lint SQL files via passing a list of files or using stdin

Usage: sqruff lint [OPTIONS] [PATHS]...

Arguments:
  [PATHS]...  Files or directories to fix. Use `-` to read from stdin

Options:
  -f, --format <FORMAT>  [default: human] [possible values: human, github-annotation-native, json]
      --config <CONFIG>  Path to a configuration file
      --parsing-errors   Show parse errors
  -h, --help    

Is recommended way creating multiple config fils with different dialects inside? Thanks! ☺️

[enricoschaaf]

I currently created multiple configs, this works for the CLI but it causes issues for the VSCode extension.

[jelder]

This would benefit from a magic comment at the top of the file, e.g.

/* scruff:dialect=duckdb */