Writing Queries

What problem does it solve?

This Skill streamlines database interactions by providing a robust framework for writing efficient SQLAlchemy ORM queries and leveraging raw SQL for complex reporting needs, ensuring data logic is well-organized and performant.

Core Features & Use Cases

• ORM Model Definition: Create SQLAlchemy models that accurately reflect database schemas.
• Repository Pattern Implementation: Encapsulate all database operations within dedicated repository classes for better code organization.
• Session Management: Ensure proper handling of database sessions with explicit commit and rollback boundaries.
• Performance Optimization: Prevent N+1 query issues through eager loading techniques.
• Hybrid Approach: Utilize raw SQL for complex queries where ORM syntax becomes cumbersome or inefficient.
• Use Case: When developing a new feature that requires creating, reading, updating, and deleting user data, this Skill guides you through defining the User model, implementing a UserRepository, and managing sessions correctly to ensure data integrity and performance.

Quick Start

Use the writing-queries skill to create a SQLAlchemy model for a 'Product' table and implement a repository to handle its CRUD operations.