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.
On this page
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.