database-operations

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