coldbox-orm-qb
OfficialCompose complex SQL queries effortlessly
AuthorColdBox
Version1.0.0
Installs0
System Documentation
What problem does it solve?
Helps developers avoid writing error-prone raw SQL by providing a fluent, database-agnostic API to construct and execute selects, joins, aggregates, subqueries, and CRUD operations within ColdBox and BoxLang applications.
Core Features & Use Cases
- Fluent Query Construction: Chainable where/join/orderBy/groupBy/having APIs to build readable queries.
- Advanced Joins & Subqueries: Support for join closures, joinSub, and subqueries as columns or filters.
- Aggregates & Pagination: Built-in count, sum, avg, min, max, forPage, limit, and offset helpers.
- CRUD and Raw Expressions: Insert/update/delete support plus selectRaw/whereRaw/orderByRaw for custom SQL when needed.
- Use Case: Build a paginated report of active users with aggregated order totals using a subquery join and database-agnostic grammar settings.
Quick Start
Use the QB skill to build and run a parameterized query that returns active users ordered by last name with pagination.
Dependency Matrix
Required Modules
None requiredComponents
Standard package💻 Claude Code Installation
Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.
Please help me install this Skill: Name: coldbox-orm-qb Download link: https://github.com/ColdBox/skills/archive/main.zip#coldbox-orm-qb Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
Agent Skills Search Helper
Install a tiny helper to your Agent, search and equip skill from 471,000+ vetted skills library on demand.