[Python] How to do a SQL Alchemy Reverse Query?

Suppose I have the SQLAlchemy code shown below. It retrieves all the users who are older than 28 years old.

Now suppose I have a u = User(name='Alice', age=30). I want to find out if u matches the filter of my_query. How can I optimally do it?

from sqlalchemy import create_engine, Column, Integer, String
from sqlalchemy.orm import sessionmaker, declarative_base

Base = declarative_base()

class User(Base):
__tablename__ = 'users'
id = Column(Integer, primary_key=True)
name = Column(String)
age = Column(Integer)

engine = create_engine('sqlite:///:memory:')
Base.metadata.create_all(engine)

Session = sessionmaker(bind=engine)
session = Session()

# Add some data
session.add_all([
User(name='Alice', age=30),
User(name='Bob', age=25),
User(name='Charlie', age=35)
])
session.commit()

# Filter users older than 28
my_query = session.query(User).filter(User.age > 28)
users = my_query.all()
for user in users:
print(f"Name: {user.name}, Age: {user.age}")

Continue reading...