To (1), I’d say we’re working right now on allowing multiple streams of data flowing into a single database, with the `Substreams:SQL` initiative, and the deployable units designs. A goal there would be to be able to join stuff from multiple chains. Take a look at the `dbt` layer too in the tutorial: https://substreams.streamingfast.io/tutorials/substreams-sql
We’re not there yet, but once we have a solid product offering, we’ll be researching the different verification layers that can apply to these technologies. There are few ideas already up there (SQL verification… in Semiotic’s wheelhouse, Firehose/Substreams runtime verification, economic security through cross-validation of multiple providers, etc…)
Nooonnn stop!