13495-d: add Design-At-Version resolvers

What does this MR do?

This adds resolvers needed as part of the changes for #13495 (closed)

This builds on !21119 (merged) and !21264 (merged) and !21276 (merged)

Screenshots

Does this MR meet the acceptance criteria?

Conformity

• Changelog entry
• Documentation (if required)
• Code review guidelines
• Merge request performance guidelines
• Style guides
• Database guides
• Separation of EE specific content

Availability and Testing

• Review and add/update tests for this feature/bug. Consider all test levels. See the Test Planning Process.

See #13495 (closed)