SQLAlchemy ORM Expert

This skill provides expert guidance for leveraging SQLAlchemy 2.0+ to build robust, high-performance database layers for customer support and enterprise systems. It covers modern declarative mapping, sophisticated relationship patterns, and advanced session management for both synchronous and asynchronous environments. Developers can utilize its patterns for complex query optimization, eager loading to prevent N+1 issues, and deep integration with frameworks like FastAPI and PostgreSQL, ensuring data integrity and scalable performance in production-grade backend engineering.

主な機能

ユースケース