Current validation covers supported reads across PostgreSQL and SQLite, with benchmark reports for Prisma v6, v7, v8, Drizzle, and generated SQL.
Every test follows a rigorous 5-step validation process to ensure generated SQL produces identical results to Prisma
Parse Prisma query arguments and generate equivalent SQL using the same models and schema. The generated SQL uses parameterized queries for security and performance.
Run the generated SQL directly via postgres.js or better-sqlite3, and execute the same query through Prisma. Both hit the same database state.
Handle type differences (BigInt vs Number, Decimal precision, Date serialization) and normalize object key ordering for fair comparison.
Verify results match exactly: same number of rows, same field values, same nested relations, same ordering. Any mismatch fails the test.
Measure execution time with 5 warmup runs, then average 10-50 iterations per test. Compare against Prisma v6, Prisma v7, Prisma v8, and Drizzle ORM.
Tests cover every Prisma read operation across multiple complexity levels
See how we validate a complex nested query with relation filters
it('nested relation filter', () =>
runParityTest(
db,
benchmarkResults,
'findMany nested relation',
'Organization',
{
method: 'findMany',
where: {
projects: {
some: {
tasks: { some: { status: 'DONE' } }
}
}
}
},
() => db.prisma.organization.findMany({
where: {
projects: {
some: {
tasks: { some: { status: 'DONE' } }
}
}
},
orderBy: { id: 'asc' }
}),
)
)
// runParityTest internally:
// 1. Calls generateSQL() with the args
// 2. Executes generated SQL directly
// 3. Executes Prisma query
// 4. Normalizes both results
// 5. Deep equality check - fails if any difference
// 6. Benchmarks execution timeThe generateSQL() function parses Prisma args and creates parameterized SQL. This step is benchmarked separately to measure query generation overhead.
Both queries hit the same database state simultaneously using Promise.all(), ensuring fair comparison and identical data conditions.
Results undergo recursive normalization: BigInt→Number, Decimal→Float(10), Date→null, JSON parse, key sorting. This ensures byte-for-byte comparison accuracy.
JSON stringify comparison with zero tolerance. Any mismatch in row count, field values, nested objects, or ordering fails the test with detailed diff output.
After validation, 5-50 iterations measure average execution time. Results include: Prisma v6, Prisma v7, Prisma v8, Drizzle ORM, Generated SQL, and SQL generation overhead.
Every benchmarked test runs across Prisma v6, v7, and v8 where supported:
All benchmark results are automatically generated and stored as JSON files for complete transparency:
Each file contains: test name, Prisma execution time, generated SQL time, Drizzle time, speedup ratios, and ISO timestamp.
The validation suite and benchmark reports are open source. Review the test code, benchmark data, and parity checks.