https://pragprog.com/titles/bksqla/sql-antipatterns/ There's an actual book on them that had me nodding along the entire time.

Agreed, it’s an excellent book by a great author. Bill is also quite prolific on Stack Overflow, and generally if you see an answer from him there, you can be confident it’s solid advice.

that's a fantastic book; one of the best i've read, and i'm glad to see it get brought up

but also, the book anti-patterns is pretty clear here