With my limited experiences with the Android Studio profiler, I see there is a way of exporting the CPU data but don't see any way of exporting the energy profiling data. Furthermore, when I try to read the source code of Android Studio, I see that the energy information is stored in a file called default.sql. However, I am not able to open this file correctly to get the information. Any help is appreciated.
Android Studio doesn't officially support exporting the energy profiling data. You are right the data is saved in a SQL file, but the schema isn't officially documented or supported. That said, you may be able to figure out the schema from the code.
Just a context, Android Studio's energy data is mathematically calculated from CPU, network, and location data. Like any maths model, it matches some devices better than others.