Build parameterized, database-agnostic SQL queries with a fluent query builder.
npx skills add https://github.com/ColdBox/skills --skill qb-coldbox
Please help me install this Agent Skill. Skill: qb Source: https://github.com/ColdBox/skills/tree/main/modules/qb Command: npx skills add https://github.com/ColdBox/skills --skill qb-coldbox
The qb skill removes the complexity and risk of writing raw SQL by providing a fluent, parameterized query builder that produces safe, portable SQL across different database engines and prevents SQL injection.
Use the qb skill to build a parameterized select query returning id, name, and email from the users table filtered by isActive.
High-intent search queries and answers about installing and using this skill.
You can build parameterized SQL queries in ColdBox using a fluent query builder that automatically binds parameters, preventing SQL injection and ensuring safe database interactions across different SQL dialects.
Yes, database-agnostic SQL is achievable by configuring SQL grammars for MySQL, Postgres, MSSQL, and SQLite, allowing the same fluent query builder code to generate portable SQL for each specific database engine.
For large datasets, a fluent query builder provides built-in pagination and chunked processing capabilities, allowing you to safely select, insert, update, or delete records in manageable batches without loading everything into memory.
Yes, the query builder supports subqueries and complex joins by chaining select, from, where, join, group, and order clauses, enabling you to compose intricate SQL reads for REST API data access layers and analytics.
Yes, you need to inject QueryBuilder@qb into your ColdBox or BoxLang application to start building parameterized, database-agnostic SQL queries safely through the fluent query builder interface.
Use raw expressions when you need database-specific SQL syntax that the fluent query builder cannot abstract, though the builder handles standard selects, joins, mutations, and subqueries across supported SQL grammars.
ColdBoxConstruct and execute database-agnostic SQL queries with the QB fluent builder.
cathayriskProvide SQLAlchemy patterns for safe database operations in Python.
ColdBoxDispatch background jobs to database, Redis, or SQS queues in ColdBox and BoxLang applications.
bughqConstruct type-safe SQL queries with a fluent API for Stacks applications.