Whether startTransaction will ensure further requests to the parent database are delayed until the callback completes.
When this returns
false, drift will manage a lock internally to ensure
statements are only sent to the transaction while its active.
For implementations that support being in a transaction and outside of a
transaction concurrently, this should return
bool get managesLockInternally => true;