Add options to the Filter recipe : "is not equal to", "in a list", "not in a list"

I'd love to have a few more sophisticated filter options. Of course, writing raw SQL is always an option, but this gets complicated.

Not equal is already available as "is different from," but "is in" and "is not in" would be nice to have for categoricals. For numericals, it'd be great if "is between" and "is not between" were options.

For the DSS engine, it'd be great if deep filtering were available for json objects and arrays.

Also, it'd be great if the visual filter builder were able to support more sophisticated logic. Currently, all the filtered values need to be combined with either and or or, but in some cases, users might want to use nested logic without needing to write an expression using formula language or SQL. This UI handles nested logic pretty well. It'd be awesome if logic like this could be expressed visually, I think it'd speed up development quite a bit and also help users intuitively understand what they're filtering for.

(
  (Condition1 OR Condition2) 
  AND 
  (Condition3 OR Condition4)
)
OR
(
  (Condition5 AND Condition6) 
  OR 
  (Condition7 AND Condition8)
)