Many developers use DISTINCT as a quick fix without understanding its scaling limitations. Create a linter that analyzes queries and suggests more efficient alternatives with explanations.
Offer a free basic analyzer with paid advanced optimization suggestions. Start with DISTINCT before expanding to other anti-patterns.
Risk includes Postgres itself improving DISTINCT performance in future versions.