Recently i was curious to get the data directly from the SQL so i do not have to manage files in OpenStudio, so i wrote a class that query all variables, merge with the variable names and index times and then you have everything on a dataframe!

Also, i corrected the ugly time format EnergyPlus uses, you can find the class with an example here:

https://github.com/AltamarMx/read_epsql/blob/main/notebooks/read_sql_class_inTesting.ipynb

it is in testing mode! suggestions are welcome!