Why I Use It
Drizzle gives me SQL-like queries with TypeScript autocomplete. The bundle size is tiny compared to Prisma, and I don't have to deal with a generated client file. The schema-as-code approach means I can version-control my database schema in Git.
When I Recommend It to a Client
When they want type safety without Prisma's weight or when they prefer SQL-first thinking over ORM abstractions. Also good for teams that care about bundle size.