Dev: Audit use of write sessions

**Describe the task**
Make sure we only use write sessions when necessary.

**Acceptance Criteria**
- [ ] All calls to `get_write_session_scope` and `get_async_write_session_scope` have been reviewed to determine if they are necessary
- [ ] A listing of instances where a read session should be used in place of a write session

**Additional context**
- No code changes required for this ticket. We can create follow on tasks if necessary.

Search the repository for calls to `get_write_session_scope` and `get_async_write_session_scope`. Review each call to determine whether it performs writes or could use a read session, then produce the requested listing of candidates; no code changes are required for this ticket.

Written by the indexing model from the issue text.