Handle with other operators besides =

[lucasbesen]

We can use raw SQL but would be nice something less handful

SELECT * FROM users WHERE id != "bla"

Something like that:

Foo.find({ name: { type: NOT, value: "James" } })

@fakenickels idea:
Foo.find({ name: Not("James") })
Not(Between (2))

A class from Operator, so we can switch on top
So we can have Not, Equal, Between
And in the query builder we detect and add the correspondent query

More ideas?

[fakenickels]

Voting for the Operator class based one, easier to code in JS and more portable to Reason

[fakenickels]

  Foo.find({
       name: {
         type: 'NOT',
         value: { type: 'BETWEEN', start: 2, end: 4 }
       },
       foo: true,
   })

Foo.find({
  name: Not(Between(2, 4)),
  foo: true,
})