unrecognized key \"$and\" for filtering

1. unrecognized key \"$and\" for filtering; 2. unrecognized key \"$between\" for filtering; 3. $or: Error 1241: Operand should contain 1 column(s)

The issue reports parsing errors for '$and', '$between', and a SQL error for '$or'. Look at the parser in the rql package, likely in a file like parser.go or ast.go, to see how filter keys are validated. Test the parsing of these operators against the supported syntax documentation. A fix would involve updating the parser to recognize these keys and generate correct SQL, then running existing tests to ensure no regressions.

Vom Indexierungsmodell aus dem Issue-Text verfasst.