Support to use SQL (SQL queries) and PPL to save as reports (then schedule for alerts and use it for dashboard panels)

[jayannah]

Is your feature request related to a problem? Please describe.
Currently the complex searches like subsearch, joins are supported by OpenSearch in SQL format queries. Subsearch and joins helps in writing most efficient search queries. But, there is no option to save SFW queries in Opensearch as reports and then schedule those report for alert notifications or for using as panels in the dashboard.

A clear and concise description of what the problem is. Ex. I'm always frustrated when [...]

Describe the solution you'd like
Enable saving the SFW queries in opensearch and provide capability to run them as alert and use them in Dashboards.

[kavilla]

Hello @jayannah,

Thank you for opening. @opensearch-project/admin can you please redirect this to: https://github.com/opensearch-project/sql

[penghuo]

Questions, what is SFW?
Are u propose alerting integration with SQL?

[jayannah]

Yes. The request is to support SQL and PPL queries for alerting in opensearch.