Backendintermediate

ORM

A tool that lets you interact with your database using your programming language instead of raw SQL.

Detailed Explanation

An ORM (Object-Relational Mapping) is a layer between your application code and database that lets you use JavaScript (or another language) instead of raw SQL. Instead of writing SELECT * FROM users WHERE id = 1, you write User.findById(1).

Popular ORMs include Prisma, Drizzle, and Sequelize for JavaScript. ORMs handle query generation, data validation, migrations, and relationship management. They make database operations feel more natural for developers.

Supabase takes a different approach: its JavaScript client (.from('posts').select()) acts like a lightweight ORM while still giving you the power of raw SQL through the SQL Editor. For most projects, Supabase's client is all you need without adding a separate ORM.

Free forever

Start building software you actually own.

Learn the concepts, fix things with confidence, and ship real products with AI beside you. No coding background required, and we're with you from the first idea to launch.

Free to start. No card. Leave whenever you want.