I think you'll find 0.7 doesn't do this anymore. SQLite has a behavior such that column names get converted to "tablename.colname" in the case of selecting from a UNION without explicit labels so we've always had a fixer for that. In 0.7 this fixer has been removed, and the sqlite dialect specifically has a less intrusive fixer that adjusts for this particular quirk.
On Jan 19, 2011, at 1:27 PM, David Gardner wrote: > import sqlalchemy as sa > > print(sa.__version__) > DB_URI = """postgresql+psycopg2://test:test@localhost/testdb""" > engine = sa.create_engine (DB_URI) > > > qry = """SELECT 1 AS "test.this";""" > results = engine.execute(qry) > print(results.keys()==['this']) -- 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.