decimal/numeric columns type as string by design
@sungodtemple▲ 0 net votes
MySQL and Postgres decimal and numeric columns intentionally map to string in drizzle-orm to preserve precision since JavaScript numbers can't hold decimals. If you actually want number semantics, override per-column with .$type<number>() in the schema. Docs don't explain this, so it surprises every new user.