(mcp) Support more filter operators and multiple order bys

[le-michael]

Description

Updated the filtering and order by schema in the query collection tool to improve LLM flexibility for constructing queries.

The new schema is closer to how we represent filters and order bys in the proto schema. However, recursive types are not support in zod so we can't have nested composite filters or recursive values.

Scenarios Tested

1. Basic greater_than query.
2. Query using the new in function, array value type, and multiple ordering.
3. Converting the query in scenario 2 into an equivalent query that represents the in operator as multiple equal operators in a disjunction.

Sample Commands

https://github.com/user-attachments/assets/d5fbd32d-097f-42ef-b40b-daabcbac0888