Here is a Python module I've developed, which abstracts away includes support for SQL queries for both tabular and Hourly/Timestep reports, has support for IP unit conversion, and also includes a Plotly-based api for generating timeseries charts (scatter, heatmap, line, histogram, etc):

https://github.com/michaelsweeney/epresults

fyi, there is also an eQUEST version with similar functionality: https://github.com/michaelsweeney/eqresults