adding a null column to s selection in sqlalchemy

Question

Hi is is possible to get a null column in sqlalchemy? For example I would like to select all user ids together with a NULL column

db.session.query(models.User.id, NULL)

The reason for this is that I need to do a UNION, which requires the same number of columns... thanks fl

r-m-n · Accepted Answer · 2016-04-23 11:56:31Z

3

from sqlalchemy.sql.expression import null
db.session.query(models.User.id, null())

answered Apr 23, 2016 at 11:56

r-m-n

15.3k6 gold badges74 silver badges71 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1