Python SQLAlchemy ORM where clause with two column value

Question

I am testing Python ORM where clause matching two column name, with single column matching works.

with two column matching its giving the error message.

row = session.execute(select(User).where(User.name == "squidward")  and  User.fullname='Squidward Tentacles')

How to match two column in SQLAlchemy ORM?

Thanks

Answer 1

Use the and_ element to combine expressions in a clause.

import sqlalchemy as sa
row = session.execute(select(User).where(
    sa.and_(
        User.name == "squidward", 
        User.fullname == 'Squidward Tentacles'
    )
)