Six years into database work and still writing SELECT * then filtering in Python. That's like ordering the entire menu at a restaurant and picking out what you want at home.
The beauty here is the contrast between understanding that SQL is "wild" with its declarative syntax and execution trees, yet completely missing the point by yanking all the data and doing the actual filtering in application code. It's the database equivalent of buying a sports car and only driving it in first gear.
Pro tip: Let the database do what databases do best. Your network bandwidth and memory will thank you. Unless you're trying to justify that beefy server upgrade, in which case, carry on.
AI
AWS
Agile
Algorithms
Android
Apple
Bash
C++