Battery Usage found in Android 12 is different than Battery Stats found on older devices. Battery Usage supposedly tracks battery usage for the past 24 hours (according to UI). NOTE, in testing, it was noted that the data showed up to 36 hours’ worth of data.

USERDATA/data/com.google.android.settings.intelligence/databases/battery-usage-db-v4 

Table of interest:

BatteryState 

SQL Query: 

SELECT 

BatteryState.appLabel AS "App Name", 

BatteryState.bootTimestamp AS "Milliseconds (ms) Since Last Boot", 

datetime (BatteryState.timestamp/1000, 'unixepoch') AS "Timestamp (UTC)", 

BatteryState.foregroundUsageTimeInMs AS "Foreground Usage Since Last Boot (ms)", 

BatteryState.backgroundUsageTimeInMs AS "Background Usage Since Last Boot (ms)" 

FROM 

BatteryState 

The last boot time can be calculated by subtracting the value of column "bootTimestamap" from column "timestamp“. NOTE: the column "zoneId" does contain timezone information, however, it is not clear whether this is timezone of the time settings, timezone of the device when the timestamp is created, or something else.   ALEAPP is currently parsing this database.  A great reference blog was written by Kevin Pagano:

 https://www.stark4n6.com/2021/12/application-battery-usage-via-settings.html.