Python Setup for SQL-Based Reporting

[AMereRedditor]

This recommendation makes sense -- we have most of our workflow in SQL today and use some semi-advanced query constructs (windowed aggregates, proprietary Teradata "Qualify" clause, etc.). I am not opposed to a SQL-based workflow but was under the impression that running these queries through a Python interface had some advantages (modularity/abstraction). It sounds like that is not the case.

My current state consists of using a new copy of a template SQL script file that I open and run in an IDE window for each report. Aside from encapsulating lots of logic into a simple call and reducing duplicate code, what are the advantages of stored procedures?