- func.count() with no argument emits COUNT(*)

1 files changed, 11 insertions, 1 deletions

diff --git a/lib/sqlalchemy/sql/functions.py b/lib/sqlalchemy/sql/functions.py
index 7303bd0c6..7fce3b95b 100644
--- a/lib/sqlalchemy/sql/functions.py
+++ b/lib/sqlalchemy/sql/functions.py
@@ -1,6 +1,6 @@
 from sqlalchemy import types as sqltypes
 from sqlalchemy.sql.expression import (
-    ClauseList, _FigureVisitName, _Function, _literal_as_binds,
+    ClauseList, _FigureVisitName, _Function, _literal_as_binds, text
     )
 from sqlalchemy.sql import operators
 
@@ -61,6 +61,16 @@ class random(GenericFunction):
         kwargs.setdefault('type_', None)
         GenericFunction.__init__(self, args=args, **kwargs)
 
+class count(GenericFunction):
+    """The ANSI COUNT aggregate function.  With no arguments, emits COUNT *."""
+
+    __return_type__ = sqltypes.Integer
+
+    def __init__(self, expression=None, **kwargs):
+        if expression is None:
+            expression = text('*')
+        GenericFunction.__init__(self, args=(expression,), **kwargs)
+
 class current_date(AnsiFunction):
     __return_type__ = sqltypes.Date