ORM

A library that lets code read and write database rows as ordinary objects, generating the SQL for you.

In more detail

ORMs save a lot of repetitive SQL but still produce SQL, and can hide expensive queries, the classic being the N+1 query problem. Inspect the SQL they generate for complex queries. Entity Framework Core, Hibernate and Prisma are examples.

Example

Java: JPA is the standard and Hibernate the usual implementation.

Related terms

Taught in

References