I'm using sqlalchemy 0.7.1 on openSUSE 11.4 (which has python2.7) but the problem was also observed with older versions of python.
Basically, with_only_columns seems to "lose" information about the columns: import sqlalchemy as sa e = sa.create_engine( 'sqlite:///' ) conn = e.connect() m = sa.MetaData() m.bind = conn t = sa.Table('a', m, sa.Column('a', sa.String()) ) t.create() s1 = sa.select( [t.c.a, sa.func.length(t.c.a), t.c.a * 2 ] ) cols = [ c for c in s1.c ] s2 = s1.with_only_columns( cols ) print s1 print s2 conn.execute(s1) conn.execute(s2) -- Jon -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.