intermediate
Drizzle ORM
Use Drizzle as a SQL-like, typed data access layer with explicit schema definitions and migration workflow.
Drizzle interviews emphasize SQL-like typed queries, schema definitions in TypeScript, and migration review. Strong candidates show when SQL proximity beats heavier ORM magic.
Subtopics: SQL-like query builder, schema definitions, migrations.
On interviews: compare Drizzle to Prisma or TypeORM on SQL visibility, migration workflow, and team SQL comfort.
Common pitfalls: assuming types fix performance; schema drift; unreadable dynamic query builders.
The trade-off is SQL transparency and control versus codegen convenience.
Checklist:
- Keep schema faithful to database semantics.
- Inspect generated SQL and plans.
- Compose dynamic filters safely.
- Align Kit migrations with deploy process.