Has SQLite ever attained multiuser functionality or is that still the main thing it lacks?
If you absolutely need high concurrency, then by their own admission pick something else. [1]
But for most things you can survive queuing up writes.
The announcement blog post:
https://sqlite.org/forum/forumpost/d9b3605d7ff40cf4
HN thread about it from a few months ago:
https://www.sqlite.org/src/doc/trunk/ext/userauth/user-auth....
The widely used Go SQLite library by mattn says it supports it, if that's useful: