Epic: Error Response for Plugin Query API

[tolzhabayev]

ON HOLD - we will take a look into this first #68480 and then revisit, so we will keep it behind a feature flag for now.

Started off from: #40444

Goal:
In case of an upstream error return a 207 status code so that plugin authors and grafana operators can differentiate between upstream and grafana errors and react correspondingly.

Issue tracking

Beta Give feedback

1. Plugins: Improve response status codes and instrumentation of /api/ds/query #45870
   area/backend/api area/instrumentation area/plugins +3
   
2. DataResponse: Add status code grafana-plugin-sdk-go#544
   enhancement +1
3. Plugins: Add support for error plane in /api/ds/query path #54664
   area/plugins +1
   
4. Chore: Update grafana-plugin-sdk-go to v0.142.0 #58115
   area/backend datasource/Elasticsearch datasource/Loki datasource/Prometheus dependencies no-backport no-changelog type/chore +8
5. Support display/visualization of data response status in the UI #58637
   type/feature-request +1
   
6. Add query data error handling to backend examples grafana-plugin-examples#108
   enhancement +1
   
7. Enhancement: Add query data error handling to datasource backend template plugin-tools#141
   create-plugin enhancement released +3
   
8. Add query data error handling to datasource-http example grafana-plugin-examples#109
   +0
   
9. datasource-http-backend: improve error handling grafana-plugin-examples#113
   enhancement +1
   
10. Support display/visualization of multiple data response errors in the UI #54665
    area/grafana/runtime area/grafana/ui area/plugins area/ux type/feature-request +5
    
11. Consider returning data responses always
12. Might introduce problems with datasources relying on /api/ds/query when testing datasource in config editor, e.g. SQL: Fix issue where testing the datasource would always be successful if the datasourceQueryMultiStatus feature was enabled #58671
13. Documentation on how to use it properly as a developer
14. Documentation on how it behaves for grafana administrators that want to monitor grafana itself