added scalar subqueries within the column clause of another select

1 files changed, 5 insertions, 1 deletions

diff --git a/lib/sqlalchemy/ansisql.py b/lib/sqlalchemy/ansisql.py
index b039b346b..6a5ef8ef0 100644
--- a/lib/sqlalchemy/ansisql.py
+++ b/lib/sqlalchemy/ansisql.py
@@ -280,7 +280,11 @@ class ANSICompiler(sql.Compiled):
 
         self.select_stack.append(select)
         for c in select._raw_columns:
-            if c.is_selectable():
+            # TODO: make this polymorphic?
+            if isinstance(c, sql.Select) and c._scalar:
+                c.accept_visitor(self)
+                inner_columns[self.get_str(c)] = c
+            elif c.is_selectable():
                 for co in c.columns:
                     if select.use_labels:
                         l = co.label(co._label)