we should be more explicit about when queries should fail with an error and when they should return empty

[stevevanhooser]

• If someone produces a query like "find field value > []", it produces an sqlite error instead of returning no matches. We should try to avoid sqlite errors.