This sounds a lot like Postgres or MySQL. Is the point of this to have compatibility with the huge number of existing SQLite applications?
People who use SQLite want to be able to scale it to handle higher concurrent write loads, including from multiple processes.
Edit: I was wrong, this makes more sense now. This isn't comparable to Postgres.