Skip to content

Object-relational mapping

Object-relational mapping (ORM) is a programming technique used in object-oriented programming languages to convert data between incompatible type systems: complex types (objects) in object-oriented programming languages and tables in relational databases.

Source content checked . English translation published 2026-10-27.

In business automation

Object-relational mapping translates objects in code into database tables. In automation, it comes into play when an internal service saves records through a code model, and the fields in the process must match the actual columns.

Examples

These examples illustrate a possible workflow. Adapt the connections and rules to your own systems.

Save a lead through a code model

The developer updates a lead object with name and phone fields. The mapping layer writes it to a table. If the automation sends a field with no corresponding column, the save fails or the value is silently dropped. Check the model before adding a new field to a form.

Relevant tools

Supabase
You can work directly with tables or through a code layer. In either case, the field name must match the actual schema.

What to check

  • Assuming that every form field exists in the table without updating the mapping can cause silent data loss.

Related terms

Sources