The dbt project at tails.com has over 600 models and 66k lines of code. With multiple contributors to a project and varying SQL backgrounds, it's really difficult to maintain consistent readability and comprehension across a codebase like that by hand.
Python has flake8, Javascript has JSLint, but SQL...?
Listen to this talk from Alan Cruickshank to find out whether SQLFluff might help your teams be more productive with SQL.