From 0bbb2c584e4e2e3f25f3d2f5731dda3ea1c26b44 Mon Sep 17 00:00:00 2001
From: Mike Bayer <mike_mp@zzzcomputing.com>
Date: Sat, 4 Feb 2006 21:51:46 +0000
Subject: [PATCH] added BETWEEN, courtesy Rick Morrison.  go Rick !

---
 lib/sqlalchemy/sql.py | 5 ++++-
 1 file changed, 4 insertions(+), 1 deletion(-)

diff --git a/lib/sqlalchemy/sql.py b/lib/sqlalchemy/sql.py
index ab46b62c05..8be40ac1da 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)
-- 
2.47.2