[Task]: Add Redis governance query read orchestration

[rian-be]

Summary

Add dedicated query read orchestration layer for Redis backed governance requests so candidate selection, document loading, and query result shaping are coordinated through clear read side pipeline.

Goal

Make Redis backed governance queries easier to evolve and reason about by separating query orchestration from candidate selection, document loading, and result materialization while preserving governance query semantics.

Scope

What should be implemented?

• Add the ModularityKit.Mutator.Governance.Redis.Storage.Queries area for governance query reads
• Add query readers for governed request, approval, and decision oriented reads
• Add orchestration for candidate selection followed by document loading
• Add materialization helpers for request, approval, and decision query results
• Add shared ordering/projection helpers where query flows overlap
• Reuse governance query evaluators for final filtering semantics
• Reuse Redis candidate selection and document loading services
• Keep query read orchestration internal to the Redis provider boundary

Acceptance Criteria

• Redis backed governance queries are exposed through dedicated query read layer
• Query orchestration is separated from candidate selection and document loading
• Request, approval, and decision-oriented reads are supported through the Redis provider
• Result shaping and ordering are reusable across query flows
• Final filtering remains aligned with governance query evaluators
• Query read logic remains internal to the Redis provider boundary and does not leak into governance abstractions

Notes

Candidate selection alone is not the Redis read side. The provider also needs coherent orchestration layer that turns candidate ids into materialized requests and then into the request, approval, and decision views expected by governance workflows.

This should align with the Redis provider query strategy and governance query API ADRs.

Related ADRs:

• ADR-026: Governance Request Query API
• ADR-029: Governance Redis Provider Package
• ADR-030: Governance Redis Request Storage and Query Strategy