sqlfmt and sqlfluff - linebreaks for SQL keywords

[ngmiduc]

I am have installed sqlfmt and sqlfluff in my python project and both work well. The problem is now that the sqlfluff linting has troubles to accept the sqlfmt formatting style. I already have added the configuration on sqlfluff but there is one issue that sqlfmt always puts smaller queries on a single line and sqlfluff wants to have the where keyword on the next line.

I was looking into the documentation but I couldn't find anything related to linebreaks except the -l parameter. Is there a way to always break lines even if the query is small.

Examples::

select * from source where col is not null

but sqlfluff wants:

select * 
from source 
where col is not null

[tconbeer]

You can configure sqlfluff to exclude/ignore the violated rules, which I think are all layout.type:

[sqlfluff]
exclude_rules = layout.indent, layout.cte_bracket, layout.select_targets, layout.spacing, layout.type
# set max_line_length to whatever you set in sqlfmt
max_line_length = 88

[sqlfluff:rules]
capitalisation_policy = lower
extended_capitalisation_policy = lower

[sqlfluff:rules:convention.terminator]
multiline_newline = True

Or you can add a single (empty) comment to force a line break in sqlfmt:

select *  --
from source 
where col is not null

[ngmiduc]

Hi!

Thanks for the answer.

The "empty single comment" to enforce the linebreak helped. I prefer that keywords like from, where, group by are on the next line. So the empty comment helped!