database-operations

name: database-operations description: Instructions on how to write database queries with SQLAlchemy.

When performing database operations using SQLAlchemy, follow these guidelines to ensure efficient and maintainable code:

• Avoid for-loops. Instead always prefer bulk operations using SQLAlchemy's built-in methods or use SQL joins to get related data in a single query.
• Database operations should be contained in repository classes