Re: [sqlalchemy] Using SQLAlchemy to check if column is in numeric ranges

You want a combination of the "between" function/method: https://docs.sqlalchemy.org/en/14/core/sqlelement.html#sqlalchemy.sql.expression.between ...and the "or_" function: https://docs.sqlalchemy.org/en/14/core/sqlelement.html#sqlalchemy.sql.expression.or_ Something like this: ranges = [(18,

[sqlalchemy] Using SQLAlchemy to check if column is in numeric ranges

Hello All!! , I have a list of age ranges i.e 18-25, 40-55 and more how can I make make a query using *SQLAlchemy* that will check if a Column is in ranges [18,25] OR [40-55] OR [60-70] Regards,Christos -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper