[FEATURE]: `PRAGMA defer_foreign_keys` for SQLite migrations

### Describe what you want

The [newly released v0.34.0](https://github.com/drizzle-team/drizzle-orm/releases/tag/0.34.0#:~:text=SQLite%20%22generate%22%20and%20%22push%22%20statements%20updates) supports creating migrations for SQLite now (🎉), however, Cloudflare D1 (SQLite) does not support `PRAGMA foreign_keys = OFF`. Instead it supports `PRAGMA defer_foreign_keys = OFF`.

It would be amazing if we can configure Drizzle Kit to generate migrations with that via `drizzle.config.ts`, so newly generated migrations don't need manual editing.

See https://developers.cloudflare.com/d1/build-with-d1/foreign-keys/#defer-foreign-key-constraints