CODEWITHSUNDEEP
sqlsqlalchemy
art.zhitnik
art.zhitnik

Reputation: 624

Number as column in SQLAlchemy query

How can I express the column "c" in SQL query like this:

SELECT a, b, 0 AS c
FROM mytable

SQLAlchemy code:

session.query(mytable.c.a, mytable.c.b, {???, c is a dynamic column})

Upvotes: 0

Views: 103

Answers (1)

art.zhitnik
art.zhitnik

Reputation: 624

from sqlalchemy.sql.expression import literal_column
session.query(mytable.c.a, mytable.c.b, literal_column(u'0').label(u'c'))

Upvotes: 1

Related Questions