[sqlalchemy] How to label columns of a union?

2016-01-17 Thread 'Dr. Leo' via sqlalchemy
Hi, consider the following snippet: from sqlalchemy import select, union u=union(select([1]).alias('foo'), select([2]).alias('foo')) u.c.keys() ['1'] u.c['1'] ua=u.alias('bar') s=select().select_from(ua) ... "1" is neither a Python, nor an SQL identifier. This makes it impossible to refer to

[sqlalchemy] Experimental Py3 port of IBM DB2 dialect

2016-01-06 Thread 'Dr. Leo' via sqlalchemy
Hi, DB2 support has so far been limited to Py2. However, there is a recent PR porting IBM_DB_SA to Py3: https://github.com/ibmdb/python-ibmdbsa/pull/8 After a few simple queries it seems to work just fine. Any other impressions, pitfall warnings etc. would be appreciated. Leo -- You