[quotemstr]

Better yet: decouple front and back ends. Let them talk over a stable interface and evolve independently. The SQLite ecosystem is evolving in this direction, in fits and starts.

[anarazel]

You can implement a different mvcc model today, without patching code.

[jeltz]

This has already been done.