[FEATURE] Create a custom hook for async queries

[ps48]

Is your feature request related to a problem?
Currently 3 plugin components make direct queries to S3. Not having a high level function creates a lot of issues on code duplication and long term maintenance. Creating a custom hook for async queries will help solve these issues

• Create a custom hook for async queries
• Re-use hook in datasources plugin component
• Re-use hook in integrations plugin component
• Re-use hook in explorer plugin component

[Swiddis]

Can we document the API that the hook will expect from the server endpoint(s)? At some point I'm going to be moving integrations setup to async jobs and would like if we could reuse the same hook.

[ps48]

From @Swiddis : we need to also sanitize the queries in his new hook: #1605 (comment)

First implementation for the hook is here. Still can be improved: https://github.com/opensearch-project/dashboards-observability/blob/76d206c18bf412d9c4c541f06c991843a113ac7d/public/framework/datasources/direct_query_hook.tsx