Include comparison operators for property value queries

[jasongoodwin]

Currently the property value queries only check for equivalence.
There are a couple ways that the queries could be improved:

• Allow ord operators for numeric types (< and >)
• Allow in and not in semantics on lists.

This would require an implicit schema - can't compare strings and numeric values, arrays, or objects directly.

See for example mongo's comparison operators:
https://docs.mongodb.com/manual/reference/operator/query-comparison/

Mongo left as a reference to unstructured store.

Postgres' json/jsonb query semantics would also be good inspiration.

[ysimonson]

Could you clarify what you mean by logical operators? We do support the ability to check that a property is or is not a given value.

Comparison operators are trickier. Since properties can be arbitrary JSON, it isn't possible to compare values (e.g. how do you compare a string to a number?) It could be doable if IndraDB added some notion of properties schema, i.e. enforce a property of a given name is a given type. To simplify things, this schema enforcement could only be applied to indexed properties. Once something like that were done, comparisons would be possible.