Add automated query analysis blueprint

What does this MR do and why?

This adds the architectural blueprint for Automated Query Analysis.

Relates to #390295 (closed)

MR acceptance checklist

This checklist encourages us to confirm any changes have been analyzed to reduce risks in quality, performance, reliability, security, and maintainability.

• I have evaluated the MR acceptance checklist for this MR.