if you were building Lint type app for stored procedures, what sort of errors would you detect?

let’s say we are talking about TSQL since that’s what I am most familiar with.

We could, let’s say, evaluate quality of exception handling and the use of transactions (or lack thereof) to recover from invalid situations. But that just sounds too cursory and boring.

What other sort of typical “dirt” is there in TSQL code bases that could conceivably be picked up with automated tools?