rqlite[1] could basically do this, if you use read-only nodes[2]. But it's not quite a drop-in replacement for SQLite at the write-side. But from point of view of a clients at the edge, they see a SQLite database being updated which they can directly read[3].
That said, it may not be practical to have hundreds of read-only nodes, but for moderate-size needs, should work fine.
That said, it may not be practical to have hundreds of read-only nodes, but for moderate-size needs, should work fine.
Disclaimer: I'm the creator of rqlite.
[1] https://rqlite.io/
[2] https://rqlite.io/docs/clustering/read-only-nodes/
[3] https://rqlite.io/docs/guides/direct-access/