Unlike .select() which requires manual SQL query composition, Drizzle Query automatically serializes relational data (fetch joins). It prevents N+1 problems and uses LATERAL JOIN (a JOIN that allows subqueries to reference values from the left table/row), making static typing easier.
Drizzle ORM - Query
Drizzle ORM is a lightweight and performant TypeScript ORM with developer experience in mind.
https://orm.drizzle.team/docs/rqb

Seonglae Cho