It appears that a development branch for a new concurrent write mode has been launched.

These appear to be page-level locks, and row-level locks should not be expected for this effort.

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