I think a not-so-small-part of the success of JS/CSS linting was that large companies like AirBnB, GitHub, and Google made their rules public and helped with sane defaults. Almost every project I came across used one of these "defaults" and added custom rules as needed.

Sqlfluff seems to ship with 48 "built-in" rules and opinions on spacing and capitalization. If it catches on, I think the larger community will mostly benefit after other companies "doing work" with it release their own collection of rules.