Drizzle ORM quiz

Test your Drizzle ORM knowledge with a free interactive quiz — 19 questions with answers and explanations. No signup needed to play.

What does `drizzle-kit generate` produce, and how does this compare to some ORMs' automatic schema sync?

1. What does `drizzle-kit generate` produce, and how does this compare to some ORMs' automatic schema sync?
2. What does Drizzle's "type inference" from schema definitions provide that raw SQL or a plain query library doesn't?
3. What does Drizzle's support for "prepared statements" (`.prepare()`) provide as a performance optimization?
4. What is Drizzle ORM?
5. What does `drizzle-kit push` do, and when is it typically appropriate to use versus `generate` + `migrate`?
6. What is the difference between Drizzle's query builder API and its "relational queries" (`db.query.users.findMany(...)`) API?
7. How does Drizzle typically handle connecting to a serverless/edge database like Neon or PlanetScale, where a traditional persistent TCP connection pool is impractical?
8. How is a Drizzle schema typically defined?
9. What does `db.transaction(async (tx) => { ... })` provide in Drizzle?
10. What is the purpose of `drizzle-kit` relative to the `drizzle-orm` package?
11. What is `$inferSelect` and `$inferInsert` (e.g. `type User = typeof users.$inferSelect`) used for?
12. How does Drizzle handle expressing SQL `WHERE` conditions, e.g. `eq()`, `and()`, `or()`, `gt()`?

More quizzes