QamoosTech
DatabasesIntermediate

ORM

Pronunciationoh-ar-EM

Definition

A tool that lets you work with database tables using objects and methods in your language instead of writing SQL.

Where you hear it

Django, Prisma, TypeORM, and SQLAlchemy discussions.

Examples

  • The ORM generates the SQL for us.
  • For this heavy report, raw SQL is faster than the ORM.

Common mistake

Never looking at the SQL it creates. An ORM can hide slow queries.