I used this approach to drive entire app, and it works. Nearly all data are fetched from SQLite. User can select a database, which can change app views, and the data. In my experience it is quite fast.

My example for android app:

https://f-droid.org/pl/packages/io.github.rumcajs.offlineweb...

Note that I am not android experienced programmer, and I am still learning.