- Added scalar() and value() methods to Query, each return a

single scalar value.  scalar() takes no arguments and is
roughly equivalent to first()[0], value()
takes a single column expression and is roughly equivalent to
values(expr).next()[0].

1 files changed, 5 insertions, 0 deletions

diff --git a/lib/sqlalchemy/orm/query.py b/lib/sqlalchemy/orm/query.py
index c9f29e6be..c2d47afea 100644
--- a/lib/sqlalchemy/orm/query.py
+++ b/lib/sqlalchemy/orm/query.py
@@ -550,6 +550,11 @@ class Query(object):
         return iter(q)
     _values = values
 
+    def value(self, column):
+        """Return a scalar result corresponding to the given column expression."""
+        
+        return self.values(column).next()[0]
+        
     @_generative()
     def add_column(self, column):
         """Add a SQL ColumnElement to the list of result columns to be returned."""