added BETWEEN, courtesy Rick Morrison. go Rick !

1 files changed, 4 insertions, 1 deletions

diff --git a/lib/sqlalchemy/sql.py b/lib/sqlalchemy/sql.py
index ab46b62c0..8be40ac1d 100644
--- a/lib/sqlalchemy/sql.py
+++ b/lib/sqlalchemy/sql.py
@@ -122,7 +122,10 @@ def not_(clause):
     """returns a negation of the given clause, i.e. NOT(clause).  the ~ operator can be used as well."""
     clause.parens=True
     return BooleanExpression(TextClause("NOT"), clause, None)
-            
+
+def between_(ctest, cleft, cright):
+    """ returns BETWEEN predicate clause (clausetest BETWEEN clauseleft AND clauseright) """
+    return BooleanExpression(ctest, and_(cleft, cright), 'BETWEEN')
         
 def exists(*args, **params):
     s = select(*args, **params)