Optimize more entity filter expressions

[seadowg]

We want more filter expressions on entity lists to be faster and not require the full list in memory. We've currently made these optimizations for = ("eq") expressions that compare values to the entity ID (name) or an entity property. We want to expand this so that the following predicates on entity items have the same performance characteristics:

• label = <value>
• <id/property/label> = <value 1> and <id/property/label> = <value 2>
• <id/property/label> = <value 1> or <id/property/label> = <value 2>
• id != <value>

[seadowg]

@lognaturel are there other expressions you think we should target here? Also, are any of the ones I've included seem like they're not as important?

[lognaturel]

That seems like a good list and it feels priority ordered from top to bottom. Maybe < and > are the same priority as !=

Relatedly, we've also talked about analyzing the form to identify columns that should be indexed. That could be a separate issue or part of this work.