Because of the relative sophistication available when using sqlite3, our application software must become more properly layered. For a REST client, we might look at a software architecture with layers.
When we are building a RESTful server, the presentation layer becomes greatly simplified. It is pared down to the essential request-response processing. It parses URIs and responds with documents in JSON or XML (or some other representation.) This layer should be reduced to a thin RESTful facade over the lower-level features.
In some complex cases, the front-most application, as viewed by human users, involves data from several distinct sources. One easy way to integrate data from diverse sources is to wrap each source in a RESTful API. This provides us with a uniform interface over distinct sources of data. It also allows us to write applications that gather these diverse kinds of data in a uniform way.