Tested with ebuild from bug 335506, test suite passes (amd64). Also tried with adding append-cppflags -DSQLITE_ENABLE_UNLOCK_NOTIFY which also worked like a charm.
Bumped. Too bad bug 342469 wasn't yet fixed.