BETWEEN queries

[Gamaroff]

Is it possible to do BETWEEN queries with the current code or would I need to develop new code to do this?

[dresende]

It's not possible, you need to develop code for now.

[dresende]

I just checked all 3 drivers and the syntax is the same so it is a good addition. I just don't know yet the best syntax for this.

[dresende]

I'm thinking about exposing some "special" functions to create "special" objects to use in conditions.

Person.find({ age: orm.between(20, 30) }, ....);

This.between() would return a common object with a non-enumerable function that would tell the sql builder what thing it is.. this could be used for other things:

Person.find({ age: orm.greater(20) }, ...);

[Gamaroff]

That sounds great. Very powerful indeed.