# drizzle-orm/release
Drizzle ORM v1.0.0-rc.4
importance: highbreakingfeatureprerelease
This release focuses on bug fixes, type improvements, and driver updates. Key changes include fixes for `View` types, `Subquery` codecs, and `sqlite` query errors, along with the addition of new driver support and improvements to the codec system.
affected
Users of `sqlite`, `pg`, and `mysql` drivers, as well as those relying on RQBv1 or specific query methods, may need to update their code.
action
Review breaking changes and update dependencies to `effect` package version `4.0.0-beta.83`.
release_signals
-Removed RQBv1 from `sqlite` and its `TSchema`, `TFullSchema` arguments from `sqlite` entities' generics
-Removed `mapResult` method from `PreparedQuery` interface and `mapResult`, `mapBatchResult` from `pg` and `sqlite` raw queries
-Split SQLite into `async`, `effect` versions (`sync` remains subtype of `async`)
-Removed `SQLiteSyncDialect`, `SQLiteAsyncDialect`, moved generic SQLite `async`\`sync` migrators to `sqlite-core/async/session`
-Bump required `effect` package versions to `4.0.0-beta.83`
+Added filesystem-less migrator for `@tursodatabase/database-wasm`
+Supported nested transactions in `@tursodatabase/database`, `@tursodatabase/database-wasm`
+Improved typed `sql` operator with `.nullable()` method
code_snippet
```typescript
// Before:
sql<Type | null>`...`.mapWith((v: any) => String(v)) // Output type: string
// After:
sql<Type | null>`...`.mapWith((v: Type) => String(v)) // Output type: string | null
// `.nullable()` method:
sql`...`.mapWith((v: unknown) => new Type(v)).nullable() // Output type: Type | null
```# community_signal
How useful is this release to your stack?
—
net score
Sign in with GitHub to cast your vote.
Sign in with GitHub to vote
You’ll return to this release, then choose your vote.