You just shard it into much smaller SQLite DBs by a partition key if you really wanted to do this.

Not really sure why you would subject yourself to this though, would be way easier just to use Cassandra/Scylla.