formattingsqlfluff

What is the difference between the 'fix' and the 'format' commands in SQLFluff?

It's not clear to me what is the difference between these two commands available in SQLFluff:

fix       Fix SQL files.
format    Autoformat SQL files.

What is the difference between the two commands?

Solution

  • From the docs:

    format

    Autoformat SQL files.

    This effectively force applies sqlfluff fix with a known subset of fairly stable rules. Enabled rules are ignored, but rule exclusions (via CLI) or config are still respected.

    So we see format is a reduced/simplified or less-aggressive version of fix. Though it's also possible the "effectively" weasel word here carries a lot of water.