Feature Master Comparison
This doc compares the ORMs benchmarked in this repo on features, architecture, and the measured SQLite numbers. It is intended as a reference for choosing a tool, not as a definitive ranking.
Caveats: Benchmark numbers are from the versions measured in
docs/BenchmarkResults.md(2026-08-18); the feature cells were re-audited against current upstream releases on 2026-09-13 (SeaORM 2.0, Prisma 7 — Rust-free client — and Drizzle 0.45 / 1.0-RC changed several answers since the measurements were taken). ruprizzle was measured at1.0.0, before it was published — the published1.5.1is a superset of what was measured, and the v1.1–v1.5 additions are listed in this table even though the numbers were not re-run. Maturity and exact feature availability can change quickly, especially for alpha/early projects. Always verify against the upstream docs for your specific use case.
Legend
- Yes — first-class, documented, supported.
- Partial — possible with caveats, extra tooling, or limited scope.
- No — not supported or not the intended workflow.
- N/A — not applicable to the tool's design.
ruprizzle (rusqlite) is the same runtime and query builder as
ruprizzle (sqlx); it only swaps the SQLite driver from sqlx::Any to the
native rusqlite crate. PostgreSQL connections still go through sqlx in both
variants.
High-level architecture
| Feature | ruprizzle (sqlx) | ruprizzle (rusqlite) | prax | sea-orm | diesel | prisma | drizzle |
|---|---|---|---|---|---|---|---|
| Language | Rust | Rust | Rust | Rust | Rust | TypeScript | TypeScript |
| Measured version | 1.0.0 | 1.0.0 | 0.11 | 1.1 | 2.2 | 6.19.3 | 0.43.0 |
| Latest version (2026-10) | 1.6.0 | 1.6.0 | 0.11 | 2.0.x | 2.3.x | 7.x (8 in RC) | 0.45.x (1.0 in RC) |
| Primary driver | sqlx (Any) | sqlx for Postgres, rusqlite for SQLite | tokio-postgres / sqlx / mysql_async / tokio-rusqlite | sqlx | libsqlite3-sys / mysqlclient / libpq | Prisma query engine + driver adapters | Node database drivers |
| Async API | Yes | Yes (sync driver called on Tokio task) | Yes | Yes | Sync (blocking) | Yes | Yes / sync driver option |
| Query style | Schema-first typed builder | Same as sqlx variant | Prisma-like fluent builder | ActiveRecord / Entity + builder | Type-safe DSL | Generated fluent client | SQL-like typed builder |
| Schema source of truth | schema.ruprizzle | Same | .prax schema | Entity files or DB first | table! macros / schema.rs | schema.prisma | TypeScript schema files |
| No hidden query engine / sidecar binary | Yes | Yes | Yes | Yes | Yes | Yes (Rust-free client since 7.0) | Yes |
SQL transparency (.to_sql() on every builder) | Yes | Yes | Partial | No | Partial | Partial | Yes (SQL-first) |
| CLI for generate / migrate | ruprizzle | Same | prax | sea-orm-cli | diesel_cli | prisma | drizzle-kit |
| Multi-tenancy / row-level security | No | No | Yes | Yes (2.0 RBAC) | No | Partial | Yes (RLS since 0.36) |
| Vector / pgvector search | No | No | Yes | Partial | No | No | No |
| Framework integrations | Any async runtime | Same | Axum, Actix, Armature | Axum, Actix, Loco, Salvo, Poem | Any | Nest, Next, etc. | Any TS framework |
Database support
| Database | ruprizzle (sqlx) | ruprizzle (rusqlite) | prax | sea-orm | diesel | prisma | drizzle |
|---|---|---|---|---|---|---|---|
| PostgreSQL | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| MySQL / MariaDB | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| SQLite | Yes | Yes (native) | Yes | Yes | Yes | Yes | Yes |
| Microsoft SQL Server | No | No | Yes | Yes (SeaORM X) | No | Yes | Yes |
| MongoDB | No | No | Yes | No | No | Yes | No |
| CockroachDB | No | No | Partial | Partial | No | Yes | Yes |
| DuckDB | No | No | Yes | No | No | No | No |
| ScyllaDB / Cassandra | No | No | Yes | No | No | No | No |
| SingleStore | No | No | No | No | No | No | Yes |
| Serverless / edge (Neon, Turso, D1, PlanetScale) | Yes | Yes | Partial | Partial | No | Yes | Yes |
| Turso / libSQL (dedicated adapter) | Yes (ruprizzle-turso) | Yes (ruprizzle-turso) | Partial | Partial | No | Yes | Yes |
| Cloudflare D1 (dedicated adapter) | Yes (ruprizzle-d1) | Yes (ruprizzle-d1) | No | No | No | Yes | Yes |
Schema & code generation
| Feature | ruprizzle (sqlx) | ruprizzle (rusqlite) | prax | sea-orm | diesel | prisma | drizzle |
|---|---|---|---|---|---|---|---|
| Declarative schema DSL | Yes | Yes | Yes | No | No | Yes | No |
| Code-first schema in source | No | No | No | Yes (2.0 entity-first sync) | Partial | No | Yes |
| Generated typed client | Yes | Yes | Yes | Partial | Partial | Yes | No |
| Schema-first migrations (diff from schema) | Yes | Yes | Yes | Partial | No | Yes | Partial |
| Introspection / codegen from existing DB | Yes (db pull) | Yes (db pull) | Partial | Yes | Partial (print-schema) | Yes | Yes |
| Compile-time query checking | Yes (ruprizzle check) | Yes (ruprizzle check) | Yes | No | Yes | N/A | No |
| Type-safe column tokens | Yes | Yes | Yes | Yes (2.0 COLUMN constants) | Yes | Yes (generated types) | Yes (typed columns) |
Type-safe nested include | Yes | Yes | Yes | Partial | No | Yes | Yes |
| LSP for schema DSL | Yes | Yes | No | No | No | Yes | No |
| Partial indexes | Yes (Postgres / SQLite) | Yes (Postgres / SQLite) | Partial | No | Partial | Partial | No |
| Expression indexes | Yes (Postgres / SQLite) | Yes (Postgres / SQLite) | Partial | No | Partial | No | No |
| Generated columns | Yes (Postgres / SQLite) | Yes (Postgres / SQLite) | Partial | No | Partial | Partial | No |
| PostgreSQL extensions from schema | Yes | Yes | No | No | No | Partial | No |
| Enum code generation | Yes | Yes | Yes | Partial | Partial | Yes | Yes |
| No runtime parser/codegen in dependency tree | Yes | Yes | Partial | Partial | Yes | No | Yes |
Query builder & type safety
| Feature | ruprizzle (sqlx) | ruprizzle (rusqlite) | prax | sea-orm | diesel | prisma | drizzle |
|---|---|---|---|---|---|---|---|
| CRUD builders | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| Raw SQL escape hatch | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| Type-safe filters | Yes | Yes | Yes | Partial | Yes | Partial | Partial |
Boolean filter combinators (and / or) | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| Projections (select subset) | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Pagination (limit / offset / cursor) | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| Ordering | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| Upsert / on-conflict | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| Bulk insert many | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| Window functions / row numbering | Yes | Yes | Yes | Partial | Yes | Yes | Yes |
| Aggregates | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| JSON operators | Yes* | Yes* | Partial | Partial | Partial | Yes | Partial |
| Array filter operators | Yes | Yes | Partial | Partial | Partial | Yes | Partial |
| Full-text search | Yes (typed tsvector/tsquery, Postgres) | Yes (same builder) | Partial | Partial | Partial | Yes | Partial |
| Soft deletes | Yes | Yes | Partial | Partial | Partial | Partial | Partial |
| Streaming / cursors | Yes (buffered + unbuffered) | Yes (buffered + unbuffered) | Yes | Yes | Yes | Yes | Yes |
Relations & advanced loading
| Feature | ruprizzle (sqlx) | ruprizzle (rusqlite) | prax | sea-orm | diesel | prisma | drizzle |
|---|---|---|---|---|---|---|---|
| One-to-many / many-to-one | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| One-to-one | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| Many-to-many | Yes 1 | Yes 1 | Yes | Yes | Yes | Yes | Yes |
| Self-referential relations | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Nested relation include | Yes | Yes | Yes | Yes (2.0 Entity Loader) | No | Yes | Yes |
| Batched / auto N+1 avoidance | Yes (bounded 1 query/level) | Same | Yes | Yes (data loader) | Manual join | Yes (join or query) | Yes |
Per-relation filters and take | Yes | Yes | Yes | Partial | No | Yes | Yes |
| Tree / hierarchy helpers | Yes | Yes | Partial | Partial | Partial | Partial | Partial |
Nested writes (create/update in one call) | Yes | Yes | Partial | Partial | No | Yes | Partial |
| Lazy loading | No | No | Yes | Yes | No | Yes | No |
Migrations & tooling
| Feature | ruprizzle (sqlx) | ruprizzle (rusqlite) | prax | sea-orm | diesel | prisma | drizzle |
|---|---|---|---|---|---|---|---|
| Automatic migration diffing from schema | Yes | Yes | Yes | Partial | No | Yes | Yes |
Migration rollback (down.sql) | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| CLI for migrate / seed / status | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| DB push (prototyping without migration files) | Yes | Yes | Yes | No | No | Yes | Yes |
| Drift detection | Yes | Yes | Partial | No | No | Partial | No |
| Offline / embedded migrations | No | No | No | Partial | Yes | No | No |
| Transactional migrations | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| Generated-crate compile-time benchmark | Yes (xtask bench-compile) | Yes (xtask bench-compile) | No | No | No | No | No |
| Browser Studio UI | Yes (ruprizzle studio) | Yes (ruprizzle studio) | No | Partial (SeaORM Pro, commercial) | No | Yes | Yes |
Advanced query builder & SQL features
| Feature | ruprizzle (sqlx) | ruprizzle (rusqlite) | prax | sea-orm | diesel | prisma | drizzle |
|---|---|---|---|---|---|---|---|
| Conditional / dynamic filters | Yes | Yes | Partial | Partial | Partial | Partial | Yes |
IN set filters | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| Count / exists queries | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| Prepared statement builder | Yes | Yes | Partial | Partial | Partial | Partial | Partial |
| Unbuffered streaming cursor | Yes | Yes | Partial | Partial | Partial | Partial | Partial |
| CTEs (non-recursive) | Yes | Yes | Partial | Partial | Yes | Partial | Yes |
| Recursive CTEs | Yes | Partial | No | No | Partial | No | No |
Set operations (UNION / INTERSECT / EXCEPT) | Yes | Yes | Partial | Partial | Yes | Partial | Yes |
EXISTS subqueries | Yes | Yes | Partial | Partial | Yes | No | Partial |
IN subqueries | Yes | Yes | Partial | Partial | Yes | No | Partial |
| Nested inserts | Yes | Yes | Partial | Yes (2.0 nested ActiveModel) | Partial | Yes | No |
| Nested updates | Yes | Yes | Partial | Yes (2.0 nested ActiveModel) | Partial | Yes | No |
Explicit JOINs | Yes | Yes | Partial | Partial | Yes | No | Yes |
| PostGIS / geospatial types | Yes (typed geo-types, Postgres) | Yes (same builder) | Partial | Partial | Partial | Partial | Partial |
Note: "Partial" for advanced SQL constructs usually means the feature is possible via raw SQL or a lower-level API, while "Yes" means a first-class builder method. ruprizzle's benchmark harness exercises every row above; availability in other ORMs is based on public documentation and the measured harness.
Observability & production
| Feature | ruprizzle (sqlx) | ruprizzle (rusqlite) | prax | sea-orm | diesel | prisma | drizzle |
|---|---|---|---|---|---|---|---|
| OpenTelemetry tracing | Yes | Yes | Partial | Partial | No | Yes | No |
| Read-replica routing | Yes (typed pool routing) | Yes | Partial | Partial | Partial | Yes | Yes |
| Query result cache | Yes (in-flight merge + TTL eviction) | Yes | No | No | No | Partial | Partial |
Measured SQLite benchmark (µs/op)
Numbers are from the latest local/cross-orm-bench/BENCHMARKS.log
(2026-08-18, 1 warm-up + 10 measured trials, medians reported; lower is better).
End-to-end operations
| Operation | ruprizzle (sqlx) | ruprizzle (rusqlite) | prax | sea-orm | diesel | prisma | drizzle |
|---|---|---|---|---|---|---|---|
select_by_pk | 25.1 | 3.1 | 17.9 | 66.8 | 9.9 | 173.1 | 39.0 |
find_many_1000 | 1,634.4 | 386.3 | 741.9 | 1,559.1 | 305.4 | 2,820.7 | 409.9 |
find_filtered_ordered | 1,797.4 | 565.4 | 925.6 | 1,603.9 | 425.3 | 3,225.3 | 504.7 |
find_filtered_paginated | 386.1 | 300.0 | 361.7 | 455.4 | 307.9 | 629.8 | 357.0 |
find_in_list | 107.7 | 30.0 | 98.8 | 130.7 | 39.6 | 404.2 | 99.0 |
find_complex_filter | 314.2 | 162.1 | 251.8 | 340.4 | 164.2 | 774.0 | 228.6 |
count_filtered | 40.1 | 20.3 | 44.4 | 91.3 | 25.7 | 170.1 | 45.8 |
exists_filtered | 20.7 | 2.7 | 22.1 | 70.0 | 9.6 | 151.4 | 41.6 |
include_posts | 21,139.9 | 7,553.3 | 10,741.2 | 20,856.5 | 3,627.0 | 40,867.0 | 188,946.9 |
include_author | 20,764.9 | 7,122.6 | 8,779.8 | 20,716.5 | 3,285.4 | 78,985.7 | 16,595.5 |
include_posts_and_comments | 131,693.4 | 59,759.2 | 41,534.5 | 114,364.3 | 20,605.2 | 251,942.4 | 9,214,149.0 |
include_posts_with_tags | 54,108.5 | 28,362.6 | 24,896.2 | 54,784.9 | 8,156.6 | 280,121.6 | 37,234.5 |
find_popular_posts | 1,458.4 | 1,266.3 | 2,058.7 | 1,671.5 | 1,275.6 | 2,805.2 | 5,655.4 |
prepared_select_by_pk | 24.6 | 2.3 | 4.9 | 84.7 | 10.0 | 194.2 | 14.9 |
stream_find_many_1000 | 2,296.3 | 705.6 | 57.1 | 1,807.1 | 225.6 | 3,290.1 | 327.0 |
bulk_insert_1000 | 1,912.4 | 1,383.1 | 1,059.0 | 6,027.3 | 6,689.7 | 14,142.5 | 9,069.6 |
Query construction (no I/O)
| Operation | ruprizzle (sqlx) | ruprizzle (rusqlite) | prax | sea-orm | diesel | prisma | drizzle |
|---|---|---|---|---|---|---|---|
to_sql_select_by_pk | 0.7 | 0.7 | 0.4 | 7.6 | 0.7 | 0.1 | 11.6 |
to_sql_select_filter_order | 1.7 | 1.7 | 1.1 | 12.3 | 1.0 | 0.1 | 17.1 |
to_sql_select_in_list | 2.5 | 2.5 | 4.3 | 25.8 | 2.7 | 0.7 | 39.4 |
to_sql_select_complex_filter | 2.0 | 2.0 | 1.5 | 14.3 | 1.1 | 0.1 | 19.8 |
to_sql_select_paginated | 1.7 | 1.7 | 1.1 | 11.8 | 1.0 | 0.1 | 18.2 |
to_sql_prepared_select_by_pk | 0.7 | 0.7 | 0.4 | 2.7 | 0.8 | 0.1 | 11.9 |
prepared_rebind_select_by_pk | 0.0 | 0.0 | 0.1 | 0.1 | 0.2 | 0.1 | 0.1 |
to_sql_conditional_filter | 1.0 | 1.0 | 0.4 | 9.1 | 0.8 | 0.3 | 15.3 |
to_sql_select_with_cte | 1.9 | 1.9 | 0.8 | 19.1 | 0.2 | 0.1 | 36.5 |
to_sql_select_with_recursive_cte | 2.8 | 2.8 | 0.5 | 25.6 | 0.2 | 0.1 | 0.1 |
to_sql_set_union | 1.8 | 1.6 | 0.9 | 17.1 | 1.1 | 0.1 | 27.3 |
to_sql_select_with_join | 1.0 | 1.0 | 0.1 | 11.4 | 1.1 | 0.1 | 30.1 |
to_sql_select_exists_subquery | 1.3 | 1.3 | 0.1 | 18.0 | 1.1 | 0.1 | 24.3 |
to_sql_select_in_subquery | 1.7 | 1.7 | 0.1 | 13.1 | 0.8 | 0.1 | 19.1 |
to_sql_nested_insert | 1.3 | 1.4 | 0.4 | 0.0 | 0.6 | 0.1 | 20.3 |
to_sql_nested_update | 0.9 | 1.0 | 0.3 | 0.0 | 0.3 | 0.1 | 17.6 |
Best-fit summary
| Criterion | Best choice | Why |
|---|---|---|
| Compile-time type safety, generated typed client | Diesel or ruprizzle | Both schema-first and fully typed; Diesel has the larger ecosystem, ruprizzle the more ergonomic generated client. |
| Maximum simple-query throughput on SQLite | ruprizzle (rusqlite) | 3.1 µs on select_by_pk — faster than Diesel's 10.0 µs — with zero async dispatch overhead. |
| Multi-row reads and filtered queries on SQLite | Diesel, then ruprizzle (rusqlite) | Diesel is fastest on most multi-row reads; ruprizzle (rusqlite) is within 20–40% and beats Drizzle/prax/Sea-ORM. |
| Bulk inserts on SQLite | prax, then ruprizzle (rusqlite) | prax leads at ~1.2 ms; ruprizzle (rusqlite) at ~1.4 ms is still roughly 4× faster than Diesel/Sea-ORM. |
| Nested relation loading, automatic batching | ruprizzle (rusqlite), then prax, then Diesel (manual) | ruprizzle's auto-batched loader is ~2× faster than Sea-ORM/Prisma; Diesel is fastest if you hand-write the join. |
| TypeScript ecosystem, migrations, team familiarity | Prisma | Largest community, mature migrations, schema-first. |
| Zero build-step / runtime schema | Drizzle | Schema is plain TypeScript, no code generation. |
SQL transparency / .to_sql() on every builder | ruprizzle, Diesel, or Drizzle | ruprizzle and Diesel expose SQL cheaply; Drizzle exposes it too but is slower to construct. |
| Production Postgres | ruprizzle, Prisma, or Diesel | ruprizzle's performance.md shows it within ~5% of hand-written sqlx on Postgres; Diesel and Drizzle are also strong on Postgres but were not measured here. |
| Multi-tenancy or vector search out of the box | prax, SeaORM 2.0 (RBAC), or Drizzle (RLS helpers) | prax advertises row-level security, schema/database isolation, and pgvector; SeaORM 2.0 ships table-scoped RBAC; Drizzle has Postgres RLS helpers since 0.36. |
Footnotes
-
ruprizzle (rusqlite) is a backend feature, not a separate ORM. It reuses the same runtime, query builder, and
schema.ruprizzleas ruprizzle (sqlx), but uses the synchronousrusqlitecrate for SQLite connections instead ofsqlx::Any. Postgres still usessqlxin both variants. -
Prisma ships a Rust query engine inside the client and uses a Node.js CLI for migration generation, so it is not "no hidden engine" in the same sense as the Rust-native libraries.
-
Drizzle is SQL-first and code-first by design; there is no separate declarative schema DSL. You write the schema in TypeScript and
drizzle-kitcan generate or push migrations from it. -
Diesel migrations are file-based (
up.sql/down.sql) and not auto-generated from a declarative schema diff, althoughdiesel print-schemacan generate aschema.rsfrom an existing database. -
Sea-ORM is entity-first: you can generate entity files from an existing DB with
sea-orm-cli generate entity, or write them by hand. It does not have a single declarative schema file as the source of truth by default. -
prax advertises very broad database support (PostgreSQL, MySQL, SQLite, MSSQL, MongoDB, DuckDB, ScyllaDB) plus pgvector, multi-tenancy, and schema import, but it is a younger project and its implementation coverage should be verified for production workloads.
-
SQLite-only benchmark: These numbers are from a single local SQLite file. Driver choice dominates simple queries, and the relative ordering can change on Postgres or with network latency. See
docs/BenchmarkResults.mdfor the full methodology. -
Newer entrants not benchmarked here: Toasty (tokio-rs, 0.x — async ORM spanning SQL plus NoSQL/DynamoDB, with Turso support) and Welds (async, sqlx/Tiberius — the only Rust ORM in this list with MSSQL). Neither was part of the August 2026 measurement; both are worth watching. SeaORM Pro is a commercial admin panel on top of SeaORM — the closest paid analogue of Ruprizzle Studio / Prisma Studio.
-
ruprizzle JSON operators are supported on Postgres (
jsonb), MySQL (JSON), and SQLite (JSON1). Postgres and MySQL support full JSON containment (@>); SQLite approximates containment with a key-existence check because JSON1 has no containment operator. SeeKnownLimitations.md. -
v1.1–v1.5 features added to this comparison: partial indexes, expression indexes, generated columns, PostgreSQL extensions from
datasource,ruprizzle checkoffline query validation, theruprizzle-lsplanguage server, and thextask bench-compilegenerated-crate compile-time benchmark (v1.1–v1.2); array filter operators, full-text search, soft deletes, declarative seeding (v1.1–v1.2); implicit many-to-many, nested writes, tree helpers (v1.3); OpenTelemetry, replica routing, query cache, PostGIS (v1.4); Ruprizzle Studio and the Turso/D1 adapters (v1.5). All shipped together in the published1.5.1.
-
ruprizzle supports both implicit many-to-many (
tags Tag[]on both sides) and explicit join models (ADR-006). With an explicitPostTagmodel you declaretags Tag[] @relation(through: PostTag)to getpost.tags,post.tags_attach(...),post.tags_set(...), andpost.tags_detach(...)with batchedincludeand transactional nested writes. ↩ ↩2