has a number of standard checks - things like SELECT * out of the box and I believe is open source.
IIRC, RedGate's SQL Test can incorporate the standard SQL Cop validations in their own unit test class which can then be run within the tSQLt/SQL Test framework. As these tests are all written in SQL - it would be easy to extend.
Another option might be to look at the work Dave Ballantyne
has done one a powershell based code parser to look for the same dort of code smells
\"Your mind is like a parachute, it works best when open\" Frank Zappa
\"Be wary of strong drink. It can make you shoot at tax collectors…and miss\" Robert Heinlein