drizzle-query

Type-safe Drizzle ORM queries for multi-table joins require importing exact schema definitions and leveraging TypeScript inference. This skill provides patterns to construct complex joins across related tables while maintaining strict data integrity and reducing backend errors.

Handling JSONB read and write operations using Drizzle ORM involves specific query patterns to read, write, and merge data within JSONB columns. This skill provides type-safe patterns for these operations to ensure data integrity in complex backend workflows.

Idempotent inserts with upserts in Drizzle ORM handle potential duplicate data by updating existing rows on conflict. This skill provides the exact query patterns needed to perform safe upserts and maintain database consistency without manual checks.

Yes, Drizzle ORM supports complex transactions for atomic multi-step operations and both offset and cursor-based pagination. This skill provides the type-safe patterns needed to implement these advanced database operations within a TypeScript backend monorepo.

Advanced Drizzle query patterns are needed for any non-trivial database operation beyond simple selects or inserts, such as multi-table joins, JSONB merging, or complex upserts. Use these patterns to ensure type safety when fetching nested relational data.