We have the same approach and has started to focus on SQLite schema development
SQL schema will reduce entities and other classes which will bring a better performance
I think SQLite is great to develop schemas and databases based on
And JSON is good for real-time usages like IoT usages