SQLFluff is designed to be used both as a utility for developers but also to be part of CI/CD pipelines.
diff-quality
pre-commit
Documentation for SQLFluff: