Bitrix D7 ORM Queries

When to use

• The user is fetching rows through the D7 ORM — a DataManager getList() with filter, select, order, or limit — or building a new query over a Bitrix entity or highload block.
• The user is deciding between the D7 ORM (ElementTable::getList) and the legacy CIBlockElement::GetList, or migrating a query from the legacy API to the ORM.
• The user needs to join related entities in the ORM — a declared Reference field, a runtime field with ReferenceField/ExpressionField, or selecting columns across the join.
• The user needs several ORM add/update/delete operations to succeed or fail atomically — starting a DB transaction and committing or rolling back around DataManager writes.