Composable query building and logical operators

Will Madden joins the podcast to talk about Prisma Next and the evolution from Prisma 7, including the decision to migrate away from Rust, ship the core through WebAssembly, and move toward a fully TypeScript ORM. The conversation dives into how modern workflows like agentic coding change the role of an ORM and why tools still matter even when agents can write SQL queries directly.

We discuss how feedback loops, guardrails, and the TypeScript type system help prevent errors, along with the new query builder, query linter, and middleware layer that analyze queries using an abstract syntax tree. The episode also covers new database capabilities including Postgres support, upcoming Mongo support, and extensions like PG Vector, enabling vector columns and cosine distance similarity search.

You’ll also learn about new patterns such as collection methods, scopes, and composable database extensions, plus tooling like driver adapters, a potential compatibility layer, and safeguards like lint rules and a performance budget middleware designed to catch expensive queries before they run.

Resources

The Next Evolution of Prisma ORM: https://www.prisma.io/blog/the-next-evolution-of-prisma-orm

We want to hear from you!

How did you find us? Did you see us on Twitter? In a newsletter? Or maybe we were recommended by a friend?

Fill out our listener survey! https://t.co/oKVAEXipxu

Let us know by sending an email to our producer, Elizabeth, at elizabeth.becz@logrocket.com, or tweet at us at PodRocketPod.

Check out our newsletter! https://blog.logrocket.com/the-replay-newsletter/

Follow us. Get free stickers.

Follow us on Apple Podcasts, fill out this form, and we’ll send you free PodRocket stickers!

What does LogRocket do?

LogRocket provides AI-first session replay and analytics that surfaces the UX and technical issues impacting user experiences. Start understanding where your users are struggling by trying it for free at LogRocket.com. Try LogRocket for free today.

Chapters

00:00 Introduction
01:00 Prisma Seven and the Move Away from Rust
02:20 Missing Features and Mongo Support
03:00 Why Prisma Started Rebuilding the Core
04:00 Community Sentiment and Developer Feedback
05:20 Rethinking ORMs in the AI and Agentic Coding Era
06:45 Why Agents Still Need ORMs
07:30 Feedback Loops and Guardrails for SQL
08:30 Type Safety and the First Layer of Query Validation
09:30 Query Linter and Middleware Architecture
11:00 Runtime Validation and Query Errors
12:30 Configuring Lint Rules and Guardrails
14:00 Designing ORMs for Humans and Agents
15:30 Collection Methods and ActiveRecord-style Scopes
17:00 Reusable Queries and Domain Vocabulary
18:30 Query Composition and Flexibility
19:00 Performance Guardrails and Query Budget Middleware
20:30 Debugging ORM Performance Issues
21:00 Query Telemetry and Request Tracing
22:30 Prisma Next Extensibility and Database Plugins
23:00 Using PGVector and Vector Search
24:00 Database Drivers and Backend Architecture
25:00 Native Mongo Support in Prisma Next
26:00 Community Extensions and Middleware Ecosystem
27:00 Runtime Schema Validation Use Cases
28:00 Writing Custom Query Validation Rules
29:00 Migration Paths from Prisma Seven
30:30 Compatibility Layers vs Parallel Systems
32:00 Prisma Next Roadmap and Timeline
34:30 What Developers Will Be Most Excited About
35:30 Final Thoughts and Community Feedback