Originally posted by **diogocp** January 7, 2022
Opensearch allows writing SQL queries. Grafana should support SQL queries because SQL allows writing more complex queries than is possible with PPL. I need to do a subquery and I'm stuck because of the lack of support for SQL.
For more information see:
* https://opensearch.org/docs/latest/search-plugins/sql/index/
* https://opensearch.org/docs/latest/search-plugins/sql/complex/
Discussed in https://github.com/grafana/opensearch-datasource/discussions/22