用sqlalchemy怎么写这样的sql语句？

Question

class Users(db.Model):
    __tablename__ = 'users'
    
    id = db.Column(db.Integer, primary_key=True)
    username = db.Column(db.String)

sql语句：

select id,username,0 as deleted from users

其中deleted不在users表中。

Answer 1

已解决

from sqlalchemy.sql.expression import literal
db.session.query(User.id, User.username, literal(0).label('deleted'))