Not sure if it's a usable concept but it sounds similar to what someone else did[1]:

> ...I implemented a virtual file system that fetches chunks of the database with HTTP Range requests when SQLite tries to read from the filesystem...

[1]: https://phiresky.github.io/blog/2021/hosting-sqlite-database...