Allow read only transactions to read immediately even if a write transaction is happening

[dimitribouniol]

Perhaps we would need a .allowsCachedReads option to make it explicit that an in-progress write will be ignored?

[dimitribouniol]

This should already work if started in a detached task.