Support for $and operand

## What is your idea?
It would be great to allow an `$and` operand, (overcoming JSON "last-one-in-wins" semantics for fields) to enable tagging multiple conditions to a given field. I think this may be possible given how I interpret the implementation of the `$or` operand. For example, this would exclude any value that (starts with "abc" AND ends with "123" AND also excludes "notmyvalue" and "alsonotmyvalue").

```
{ "$and": [
{"myField": [{"anything-but": ["notmyvalue", "alsonotmyvalue"]}]},
{"myField": [{"anything-but": {"suffix": "123"}}]},
{"myField": [{"anything-but": {"prefix": "abc"}}]}
]
}
```

## Would you be willing to make the change?
Maybe

## Additional context

Add any other context (such as images, docs, posts) about the idea here.

Start by reviewing the existing $or operand implementation and the example in this issue, focusing on how multiple conditions for one field are represented and matched. The work is done when an $and operand supports the shown combination of conditions without JSON last-one-in-wins behavior.

Written by the indexing model from the issue text.