Drizzle ORM offers SQL-like syntax with full TypeScript inference. Write queries resembling SQL while getting complete type safety. Migrations generate from schema changes. Minimal runtime overhead.
Schema Definition
Define tables with TypeScript. Columns specify types and constraints. Relations connect tables explicitly. Schemas export for query building and migrations.
- Define schemas with type-safe column definitions
- Export types from schemas for application use
- Use relations for explicit table connections
- Generate migrations from schema changes
- Query with SQL-like syntax preserving types
Query Building
Queries use familiar SQL patterns. Select, insert, update, delete operations chain fluently. Joins preserve types across tables. Subqueries and CTEs work naturally.