KQL support in filter ratio in TSVB

[AlonaNadler]

Describe the feature: Over the past few weeks, I got several requests and frustrated users who missed the fact filter ratio doesn't support KQL and couldnt figure why they get errors on valid kql queries in filter ratio in TSVB.
Currently there is no indication that filter ratio doesn't work with KQL and only supports Lucene. Users past queries that are working in Discover and get errors in TSVB which can't be explained.

Since KQL is the default starting from 7.0 it will be good to support it in TSVB filter ratio.

cc: @timroes

[elasticmachine]

Pinging @elastic/kibana-app (Team:KibanaApp)

[timroes]

For reference the implementation when switching Filters aggregation in the visualize editor over to use KQL: #37287