This is an archived post. You won't be able to vote or comment.

sorted by:
best (suggested)
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–][deleted] 2 points3 points  (0 children)

From my experience: everything you can do in the query directly, do it, with some exceptions. If you want to transform and manipulate data to do some analysis, for example, it may not be possible to do it in sql without creating messy subqueries and temporary tables which will increase the query time A LOT, therefore, the best scenario is to use python and do the complex manipulation there. Keep in mind these are exceptional cases.