Also have wanted this. Operating on data locally means it can be fast and low latency (on device, not between devices).

I think the secret lies in using CRDTs to sync data in a way that allows it to be processed into another system. E.g. Postgres on a server and SQLite on a phone.