Hi,
I would like to know the best way of indexing data on moralis.
Example use case, I want to query the total amount of gas a contract/address has consumed. From traditional sql i would create a view query with columns address and gas that gets updated every hour.
My front end code will then query the data and display it
I wonder if that is possible with moralis sdk/api