Thanks! The HIVE rewards themselves do not capture the true essence of each community's economic impact.
Of course, if you are only using HiveSQL, you won't get the H-E tokens (unless you parse the JSONs, which would be near impossible). It would take queries from H-E, which I don't think has any sort of SQL-based interface.
However, if you just look at the total number of H-E tokens issued by each community each month, and take into account each community's author/curator reward breakdown, you should be able to add that in.
With the growing number of communities and community tokens (and the growing cumulative valuation of H-E tokens), maybe @arcange (or someone) should develop an SQL interface for H-E 😀.
Actually HiveSQL does capture all Hive data including H-E token transactions. However, there is this issue of some transactions being recorded on Hive twice due to some error or bug on Keychain or something. So getting H-E transactions using HiveSQL is not a problem, the problem is it can't tell when there is a double record and which one is error. So the end result would not be accurate.
I did start using hiveengine api recently, and with help was able to get balances of tokens. I didn't explore it further than that yet. But it will be an interesting learning experience to do so.