As sqlite needs to create -journal or -wal/-shm files in same directory
as database, if you symlink, hardlink, (and any possible variation, like
mount --bind, overlayfs, fuse, network mounts, 9p, etc) database to
different names, and attempt to access them at once, things will break.
In a hard way.
This is *documented* to *not* work.
See /usr/share/doc/sqlite3-doc/howtocorrupt.html, "Multiple links to the
same file".
In the best case, sqlite will warn you and won't work. But more often
you should expect silent database corruption.
Disclaimer: not a maintainer.