[Dashboard][Lens] Provide API to collect all generate queries from each panels

[dej611]

Describe the feature:

Starting with the PoC in #173416 build a solid API to collect all queries from a given dashboard/visualization.

In order to achieve that it is required some basic foundational tasks:

• move most of the required code into common (within Lens or even in a separate module)
  • this means splitting the presentation from the logic part of many modules (i.e. form_based operations)
• export a wrapper function for the service
• expose a new kibana server API endpoint (dashboard only?)

Describe a specific use case for the feature:

Possible use cases:

• enabler for [Reporting] Exporting raw data from table-based visualizations #30982
• Integration query analysis useful for ES team & regression testing (see [TSDB & LogsDB] Collect all related queries in integrations for testing #178066 )
• Validating integration dashboards Add automated tests with dashboards elastic-package#1705

[elasticmachine]

Pinging @elastic/kibana-visualizations (Team:Visualizations)

[drewdaemon]

duplicate with #175487?

[drewdaemon]

Or we could view this issue as the Lens piece and the other as the larger ask. Not sure how you want to slice and dice