[BUG]: [SQLITE] Push command show SQL to apply with no schema changes about drizzle-orm HOT 3 OPEN

Upon some further investigation on a fresh local DB, it all seems to work, just the production turso DB I'm connecting to does not want to get fixed by push.

from drizzle-orm.

Also I was getting a warning about the table needing to be dropped because it's not null and missing a default value when I tried adding a new column although the column definition was orderIndex: integer('orderIndex').default(0).notNull()

from drizzle-orm.

Update: I've found a workaround. With strict and verbose flags enabled, I was able to see the SQL that the drizzle-kit is trying to apply and then manually apply relevant queries myself directly.

from drizzle-orm.