Drizzle infers row types from the table object itself with $inferSelect and $inferInsert

Every Drizzle table carries two type helpers as properties on the object: typeof users.$inferSelect for the shape a select returns and typeof users.$inferInsert for the shape insert accepts, where columns with a default or marked nullable become optional. The standalone equivalents are InferSelectModel<typeof users> and InferInsertModel<typeof users>.

The older single InferModel helper, parameterised with a mode string as in InferModel<typeof users, 'insert'>, is deprecated and produces the wrong optionality on insert for columns that have defaults, so it should be replaced. These are the right types for function signatures instead of hand-written interfaces, because a schema change then surfaces as a compile error at every call site. For a query with joins or a partial select, derive the type from the query's own return type rather than the table-level helpers, which describe only the base table.