bx-orm-querying

What problem does it solve?

This Skill enables developers to query and manage ORM entities in BoxLang, providing consistent patterns for loading, persisting, and mutating data while reducing boilerplate.

Core Features & Use Cases

• EntityLoad(): load multiple or single entities with filters, sorting, and pagination.
• EntityLoadByPK(): load by primary key, including composite keys.
• EntityLoadByExample(): load by example prototype entities.
• ORMExecuteQuery(): run HQL-like queries with named or positional parameters, with optional pagination and caching.
• Entity lifecycle BIFs: entitySave, entityDelete, entityNew, entityMerge to manage persistence across transactions.
• Use Case: fetch active users, apply sorting, and persist updates in a transaction.

Quick Start

Load active users with entityLoad and a simple filter, apply pagination, and persist changes with entitySave inside a transaction.