How to make custom E+ SQL output for DView

edit

I can help you get into the Sqlite files. On free tool in windows is "sqlitebrowser" which can be installed here: https://sqlitebrowser.org/dl/. There are other database IDE's (Dbeaver being another good one) but if you just need sqlite3 browsing this should work.

Now an incomplete summary of the Sqlite structure is shown in the next 3 images:

Table Structure of the SQLITE Outputs:

Data Elements of the Meters that are outputs as reports:

The location of the observations for each meter:

Now for an example, if you wanted to return all of the results of "Electricity:Building" for each run period you could use the following query in the "Execute Query" tab. To return all results remove the final line "Limit 500" or comment it our with two dashes before the line "--".

Select t.*,RMD.VariableValue
from ReportMeterData RMD
join time t on t.TimeIndex=RMD.TimeIndex
where RMD.ReportMeterDataDictionaryIndex = 26  --Electricity:Building
Limit 500;

Image of the following query is here:

Per your question of joining the two sql lite files I don't think this is feasible but I haven't looked into Dview. By using these queries you could also setup Python to extract the values you want and visualize both of them in a Python visualization. This link could help if you explored that path further: https://docs.python.org/3/library/sql....

Dview already allows comparing results from multiple simulations:

1. Launch DView, click File -> Open, and select the first EnergyPlus sql file.
2. Click File -> Append and select the second EnergyPlus sql file.

This will produce something like this: