I'll tell you my use case, I'm building a keyword based search bar functionality where in the user can enter some keywords which will be autosuggested to the user. These could be some columns from a table and some other keywords like "by", "in" , etc. One example of this could be: " number_of_school by state_name" here "number_of_school" and "state_name" are columns and "by" is a keyword.

I need a way to create elastic search query for this so I need to figure out on which field to apply term aggregation, and as the query string grows large, will also need to figure out about nested,multiple aggregations and filters.

Any leads how can I proceed with this?