My guess is that, with the oncoming changes for concurrent writers, these will be implemented in time.

Still, Rome was not built in a day, and functionality must take a backseat to reliability and legacy compatibility.

https://www.sqlite.org/cgi/src/doc/begin-concurrent/doc/begi...