drizzle-team / drizzle-orm

Headless TypeScript ORM with a head. Runs on Node, Bun and Deno. Lives on the Edge and yes, it's a JavaScript ORM too 😅
https://orm.drizzle.team
Apache License 2.0
21.44k stars 484 forks source link

[BUG]: Drizzle-typebox types SQLite real field to string #2524

Open StevenStavrakis opened 1 week ago

StevenStavrakis commented 1 week ago

What version of drizzle-orm are you using?

0.31.1

What version of drizzle-kit are you using?

0.22.7

Describe the Bug

If you create a SQLite schema and and generate a TypeBox object with it, it will make any columns using the real datatype a string.

Expected behavior

real stores a floating point number in SQLite. I would expect the generated type for the column to be number

Environment & setup

No response