But then you need the write lock for all the databases (assuming your transaction involves writes).

Unfortunately if you use WAL mode the transactions are only isolated per database file.

https://www.sqlite.org/lang_attach.html