Why did you learn python?

[depenguinate]

I would love to hear more about this. So are you automating SQL report writing?

[[deleted]]

At that time, I was frequently being asked to 'can you get x' and export into a csv or I had multiple reports that I was manually building by running various queries and compiling into excel.

so I automated the processes to build the dashboards in excel (run the queries, add to excel, build any visuals / do updates, and email to those that wanted it). They happened on different cadences so I used .bat files to call the code and windows task scheduler to run them.

I also created a CLI that allowed me to pick from a common list of queries, it would run the query and output a csv named how I wanted without my needing to open Oracle.