Consider supporting OrderBy, Limit

[eparejatobes]

No description provided.

[eparejatobes]

It is pretty common querying by a property p1 and then sort using p2. Fully supporting this (or similar patterns) involves adding complexity to indexes (which I don't like), or having a proper Query interface. For the second option, Queries are built on an element type, and have methods (them or query builders, whatever)

/* for building queries */
<X> Query<FT> and(
  Property<FT,X> property,
  QueryPredicate.Compare predicate,
  X value
);

<X> Query<FT> or(
  Property<FT,X> property,
  QueryPredicate.Compare predicate,
  X value
);

/* this the equivalent of executing the query */
Stream<V> orderByWithLimit(Property<FT,?> property, Int max);

As for the implementation, we could store inside the query a list of predicates together with how they are combined.

@laughedelic WDYT?

[laughedelic]

If it's only about indexes, I would make just necessary changes in indexes. I see query-builder thing as an overkill for this.