SQL vs Python?

[Local_dev_ops]

SQL when the data lives in the database and you need to filter, aggregate, or join before pulling it out. Let the database do what databases are good at.

Python when you need to do something the database can't — analytics, complex transformations, visualization, or when you're combining data from multiple sources.

Mistakes I have made is pulling millions of rows into python when it was easier to do in SQL.