Why BETWEEN is error prone

We do not use BETWEEN for now, and chances are we’ll never expose it as a direct operator in our query¬†builder. Sure, there are pros and cons on using x BETWEEN a AND b rather then x >= a AND x <= b, and that’s one reason why we have this article. However, assuming our tool tries to avoids as much as possible error prone SQL constructs and the “element of surprise”, it seems like the bad won over the good. (more…)