Is there an existing issue for this?

• I have searched the existing issues

Is your feature request related to a problem? Please describe.

I'd like to retrieve a prediction filtering over a range of values rather than only individual exact values. Example:
select rental_price, rental_price_explain
from mindsdb.home_rentals_model
where sqft between 1000 and 1200 and neighborhood in ('berkeley_hills', 'westbrae', 'downtown');

This currently generates an error:
Only 'and' and '=' operations allowed in WHERE clause, found: BetweenOperation(op='between', args=( Identifier(parts=['sqft']), Constant(value=1000), Constant(value=1200) )

Describe the solution you'd like.

I'd like to have the ability to use filter criteria such as "in", "between", or "or" logic to retrieve a single prediction.

Describe an alternate solution.

No response

Anything else? (Additional Context)

https://mindsdbcommunity.slack.com/archives/C01S2T35H18/p1672320517307839