Search: add SQL WHERE clause support to our API?

Would our API be more approachable if we let users query it with SQL using something like https://www.elastic.co/what-is/elasticsearch-sql

This may make it easier for users to customize their search query filtering. Similar to our existing filtering we wouldn't need to support the entire syntax.

Start by locating the API's existing search filtering behavior and comparing it with the linked Elasticsearch SQL example. Determine whether a limited SQL WHERE syntax is appropriate, which subset would be supported, and how completion would be validated against the current filtering behavior.

Written by the indexing model from the issue text.