Dyota's blog

sqlfluff

sqlfluff rules reference

Run this in the shell and it will do the whole folder:

sqlfluff format
[sqlfluff]
dialect = tsql
templater = raw
indent_width = 4
max_line_length = 900

[sqlfluff:indentation]
indent_unit = space
indent_width = 4
indented_joins = true
indented_using_on = false

[sqlfluff:rules:layout.select_targets]
wildcard_policy = single

[sqlfluff:rules:convention.select_trailing_comma]
select_clause_trailing_comma = forbid

[sqlfluff:layout:type:comma]
line_position = leading

[sqlfluff:rules:capitalisation.identifiers]
extended_capitalisation_policy = lower

[sqlfluff:rules:aliasing.expression]
aliasing = explicit

[sqlfluff:rules:aliasing.column]
aliasing = explicit

[sqlfluff:rules:aliasing.table]
aliasing = explicit

[sqlfluff:rules:references.quoting]
quoted_identifiers_policy = all_identifiers

[sqlfluff:rules:layout.long_lines]
ignore_comment_lines = true