I might do something similar in the main. Still, this doesn't inherently solve the problem. That is, you would still need to be aware of transaction isolation

I might do something similar in the main. Still, this doesn't inherently solve the problem. That is, you would still need to be aware of transaction isolation levels and ensure that you're locking rows properly as you conduct each transaction.