Select as in sqlalchemy

Question

I want to do something like this:

select username, userid, 'user' as new_column  from  users_table. 

The columns of the table can be selected using sqlalchemy as follows:

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

How do I do the select x as col_x to the query in sqlalchemy?

Answer 1

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;