I set up a demo project for how to use SQLFluff with Meltano and DBT. SQLFluff still has a few rough patches, but it's much more mature than it was a few months ago when we started using it to the point I feel comfortable recommending it to others: https://gitlab.com/rabidaudio/meltano-sqlfluff-example

Agree with this! I have enjoyed applying it to our project as we add new models — works surprisingly well, especially if you suppress a couple bad offender fixes (eg, the “Put simple selects before transformations” rule)