Select as in sqlalchemy

Use the label(...) function: users_table.c.userid.label('NewColumn')

i.e.,

query = select([users_table.c.username, users_table.c.userid.label('NewColumn')])

evaluates to:

SELECT username, userid as NewColumn From MyTable;