Drizzle ORM patterns

Assume Drizzle 1.0.0-beta.1+ and Relational Query Builder v2 unless the installed package or codebase explicitly proves otherwise. In this model, db.query.* is the v2 API and relations are defined with defineRelations.

For formatting of relational queries and SQL builder chains, especially when a query mixes columns, where, and with or builder helpers like .select() and .where(), read references/formatting.md. Use that layout consistently in generated examples and code review suggestions because deep Drizzle configs get hard to scan when everything is packed onto a few lines.

Version cues

Treat these as current Drizzle v1 beta patterns: