ORM

Object-relational mappers (ORMs) provide a way to define and interact with databases through application code instead of hand-writing all SQL queries.

They improve developer productivity and can reduce database-specific boilerplate.

Prisma

• Type-safe database client
• Supports many databases
• Easy relation API

Mongoose

• For MongoDB and Node.js
• Create Models and Schemas
• middleware support

Sequelize

• For Node.js and MySQL
• Supports SQL-based databases
• Migrations, model associations, and hooks

SQLAlchemy

• Python
• Supports MySQL, PostgreSQL, SQLite, and OracleDB
• Rich API for complex queries

See also: MOC Computing DevOps and Software