SQL ANTI-PATTERNS YOU SHOULD AVOID

Summary from the TLDR Dev newsletter

Some common SQL anti-patterns include mishandling CASE WHEN statements, using functions on indexed columns, overusing DISTINCT, excessive view layer stacking, using SELECT * in views, and using nested subqueries. Treating SQL like production code, including reviewing and optimizing, can prevent these issues and improve data trust.