How do I perform queries using SQLAlchemy?

How do I perform queries using SQLAlchemy?

You can perform queries in SQLAlchemy using the session object. For example, to query all users, you can use: session.query(User).all().

What if I want to filter the results?

You can use the filter method. For example: session.query(User).filter(User.age > 30).all() will return users older than 30.

Can I sort the results as well?

Yes, you can sort results using the order_by method. For example: session.query(User).order_by(User.name).all() will sort users by name.

How do I limit the number of results returned?

You can use the limit method. For example: session.query(User).limit(5).all() will return only the first 5 users.