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?
Maybe literal_column?
query = select([users_table.c.username, users_table.c.userid, literal_column("user", type_=Unicode).label('new_column')])
See https://docs.sqlalchemy.org/en/13/core/sqlelement.html#sqlalchemy.sql.expression.literal_column
Edit: actually I should have said "literal":
query = select([users_table.c.username, users_table.c.userid, literal("user", type_=Unicode).label('new_column')])