sqlalchemy To query the desired value

I'd like to get the data in the column called "confirmed" that the username variable has in the table called User to sqlalchmey

date_data = db.session.query(User).filter(User.confirmed == username).first()

I wrote it like this, but there was no error and the price was not printed at all.

Just connect. SELECT confirmed FROM user WHER username = username; How do I approach this to see the same effect?