sqlite-expo primary key auto increment is generating a text column instead

SQLite

drizzle orm

Hey guys, i'm using drizzle with expo sqlite, i'm trying to create an auto increment calumn as said in docs here:https://orm.drizzle.team/docs/column-types/sqlite

integer({ mode: 'number' }).primaryKey({ autoIncrement: true })

integer({ mode: 'number' }).primaryKey({ autoIncrement: true })

and generate the migration correctly like this:

CREATE TABLE `acts` (
    `id` integer PRIMARY KEY AUTOINCREMENT NOT NULL,
);

CREATE TABLE `acts` (
    `id` integer PRIMARY KEY AUTOINCREMENT NOT NULL,
);

but when i the pragma command to inspect the table, i find that it creats the id as TEXT and not integer with auto increments.

PRAGMA table_info(acts);
0|id|TEXT|1||1
...

PRAGMA table_info(acts);
0|id|TEXT|1||1
...

Drizzle ORM is a lightweight and performant TypeScript ORM with developer experience in mind.