Consider supporting inconsistent reads for saga lookups

[danielmarbach]

Describe the suggested improvement

Currently, all non-pessimistc saga lookups are using consistent-reads. Theoretically, it would be possible to allow inconsistent reads at the cost of potentially running into more optimistic concurrency violations on contended sagas. This might be a nice cost optimization for certain scenarios.

When using pessimistic locking the record is read with an update with return results ALL therefore non-consistent reads do not apply there.

Additional Context

No response