[sql] Support efficient scans for simple `Expr`s

[igalshilman]

We should make the queries to our partitioned tables (inobx, outbox, journal, and state) more efficient, if the query provides a constraint on a service and a key