Report hasn't been filed before.

• I have verified that the bug I'm about to report hasn't been filed before.

What version of drizzle-orm are you using?

1.0.0-beta.20

What version of drizzle-kit are you using?

1.0.0-beta.20

Other packages

No response

Describe the Bug

Hi folks. I'm using drizzle in some project and catching up newest release.
I found drizzle-kit migrate fails when using it with Cloudflare D1.
I researched codebase:

1. Remote SQLite like Cloudflare D1 doesn't support transaction and therefore drizzle has sqlite-proxy module. In this module additional function batch is implemented.
2. In migration process, session.transaction called.
   

   drizzle-orm/drizzle-orm/src/up-migrations/sqlite.ts

   Line 428 in 1a01082

   await session.transaction(async (tx) => {

3. SQLiteRemoteSession implements transaction but it starts with begin statement. This is unsupported in Cloudflare D1.
   

   drizzle-orm/drizzle-orm/src/sqlite-proxy/session.ts

   Line 115 in 1a01082

   override async transaction<T>(

IMHO, there are two ways:

1. use batch in transaction(): modify sqlite-proxy/session.ts
2. implement another up-migration as up-migration/sqlite-proxy.ts and use it from sqlite-proxy/migrator.ts.

Do you have any plan to handle this?