drizzle-orm-patternslisted

# Drizzle ORM Patterns - Complete PostgreSQL Reference **Use when:** Working with database operations, schema design, migrations, or queries in Quetrex. ## Overview This skill provides comprehensive Drizzle ORM patterns for PostgreSQL with Vercel Edge Runtime support. Drizzle is Quetrex's chosen ORM because it's edge-first, type-safe, and supports all deployment targets. ## Why Drizzle? - **Edge Runtime Compatible**: Works with Vercel Edge Functions, Cloudflare Workers - **Type-Safe**: Full TypeScript inference without code generation - **Zero Dependencies**: No heavy Node.js runtime requirements - **SQL-Like API**: Familiar to developers who know SQL - **Lightweight**: ~7.4kb minified (vs Prisma's ~300kb) ## Skill Structure This skill is organized into focused modules: ### 1. [queries-complete.md](./queries-complete.md) Complete query patterns: select, insert, update, delete, joins, pagination, filtering, aggregations, subqueries, CTEs. **When to use:** - Building any database query - Fetching data with filters - Inserting/updating/deleting records - Pagination or sorting - Aggregating data (count, sum, avg) - Complex joins or subqueries ### 2. [transactions.md](./transactions.md) Transaction patterns: isolation levels, rollback, nested transactions, error handling, deadlock prevention. **When to use:** - Multiple operations that must succeed together - Financial operations (payments, transfers) - Data consistency requirements - Race condition prevention - Complex