If I use drizzle push on an empty turso db the first push works fine. (command: "pnpm db:push") After that if I run push again, it thinks that the schema doesn't match and it applies some changes. On the third db:push attempt it tries to do the changes again but this time it fails and it leaves the db in an "broken" state. (Because It has some _old tables left and the new ones are missing the values of the _old one.)
I see two issues here. 1) Drizzle kit sees schema changes which are actually not there. 2) Drizzle kit is not pushing in a transaction and on error it is not getting rolled back