What are some examples of queries using Flask ORM?

Can you show me some examples of how to use Flask ORM for querying a database?

Sure! Flask ORM, often used with SQLAlchemy, allows you to interact with your database easily. For example, to query all users, you can use:

users = User.query.all()

This retrieves all records from the User table.

What if I want to filter users by a specific attribute?

You can use the filter method. For instance, to find users with the name 'Alice':

alice_users = User.query.filter(User.name == 'Alice').all()

How can I sort the results?

You can chain the order_by method. For example, to sort users by their creation date:

sorted_users = User.query.order_by(User.created_at).all()

Can I limit the number of results returned?

Yes, you can use the limit method. For example, to get only the first 5 users:

limited_users = User.query.limit(5).all()