PHPackages jardissupport/dbquery - PHPackages - PHPackages [Skip to content](#main-content)[PHPackages](/)[Directory](/)[Categories](/categories)[Trending](/trending)[Leaderboard](/leaderboard)[Changelog](/changelog)[Analyze](/analyze)[Collections](/collections)[Log in](/login)[Sign up](/register) 1. [Directory](/) 2. / 3. [Database & ORM](/categories/database) 4. / 5. jardissupport/dbquery ActiveLibrary[Database & ORM](/categories/database) jardissupport/dbquery ===================== Fluent SQL query builder with CTEs, window functions, subqueries, and JSON support for MySQL, MariaDB, PostgreSQL, and SQLite v1.0.3(3w ago)0398↓82.2%1MITPHPPHP >=8.2CI passing Since Jun 2Pushed 3d agoCompare [ Source](https://github.com/jardisSupport/dbquery)[ Packagist](https://packagist.org/packages/jardissupport/dbquery)[ Docs](https://jardis.io)[ RSS](/packages/jardissupport-dbquery/feed)WikiDiscussions main Synced 2d ago READMEChangelog (4)Dependencies (15)Versions (9)Used By (1) Jardis DbQuery ============== [](#jardis-dbquery) [![Build Status](https://github.com/jardisSupport/dbquery/actions/workflows/ci.yml/badge.svg)](https://github.com/jardisSupport/dbquery/actions/workflows/ci.yml/badge.svg)[![License: MIT](https://camo.githubusercontent.com/784362b26e4b3546254f1893e778ba64616e362bd6ac791991d2c9e880a3a64e/68747470733a2f2f696d672e736869656c64732e696f2f62616467652f4c6963656e73652d4d49542d677265656e2e737667)](LICENSE.md)[![PHP Version](https://camo.githubusercontent.com/a68b290dcc313d698dc138a1111aa83eee2f143605449d7e8b5416ea6f88558f/68747470733a2f2f696d672e736869656c64732e696f2f62616467652f5048502d253345253344382e322d3737374242342e737667)](https://www.php.net/)[![PHPStan Level](https://camo.githubusercontent.com/c51bda247654363d3e30bc352674dd761a9557803a14af0226eb411d6dc0006b/68747470733a2f2f696d672e736869656c64732e696f2f62616467652f5048505374616e2d4c6576656c253230382d627269676874677265656e2e737667)](phpstan.neon)[![PSR-12](https://camo.githubusercontent.com/34b10db0caa29bacd49bda5c437a8de95385f036f3230b31fa605326e18da22c/68747470733a2f2f696d672e736869656c64732e696f2f62616467652f436f64652532305374796c652d5053522d2d31322d626c75652e737667)](phpcs.xml)[![Coverage](https://camo.githubusercontent.com/407e6392b5d053d37f61cc9e717081440e2bb200d8b82bde96322233eb547016/68747470733a2f2f696d672e736869656c64732e696f2f62616467652f436f7665726167652d39362e36352532352d627269676874677265656e2e737667)](https://github.com/jardisSupport/dbquery) > Part of **[Jardis](https://jardis.io)** — the Domain-Driven Design platform for PHP. You model your domain; Jardis generates the production-ready hexagonal code (DTOs, Command/Query handlers, repositories, persistence). This package is part of the open-source foundation that generated code runs on. A fluent SQL query builder for PHP that generates dialect-aware SQL for MySQL, MariaDB, PostgreSQL, and SQLite. Full support for CTEs, window functions, subqueries, JSON columns, and prepared statements. SQL injection protection built in. --- Features -------- [](#features) - **Dialect-Aware SQL** — generates correct syntax for MySQL, MariaDB, PostgreSQL, and SQLite from a single builder - **CTEs** — `with()` and `withRecursive()` for common table expressions - **Window Functions** — `selectWindow()`, `window()`, and `selectWindowRef()` for analytics queries - **Subqueries** — subqueries in FROM, JOIN constraints, SELECT columns, and WHERE EXISTS / NOT EXISTS - **JSON Column Support** — `whereJson()`, `andJson()`, `orJson()`, `havingJson()` for structured JSON field conditions - **Union / Union All** — `union()` and `unionAll()` compose multiple SELECT statements - **Prepared Statements** — `sql($dialect, prepared: true)` returns a `DbPreparedQueryInterface` with bound parameters - **SQL Injection Validation** — bracket and expression validation built into `sql()` before generation - **INSERT Conflict Handling** — `DbInsert` supports ON DUPLICATE KEY (MySQL) and ON CONFLICT (PostgreSQL) --- Installation ------------ [](#installation) ``` composer require jardissupport/dbquery ``` Quick Start ----------- [](#quick-start) ``` use JardisSupport\DbQuery\DbQuery; $query = (new DbQuery()) ->select('id, name, email') ->from('users') ->where('status')->equals('active') ->and('created_at')->greaterEquals('2024-01-01') ->orderBy('name') ->limit(50); // Generate prepared SQL for MySQL $prepared = $query->sql('mysql', prepared: true); // $prepared->sql() → "SELECT id, name, email FROM users WHERE status = ? AND created_at >= ? ORDER BY name ASC LIMIT 50" // $prepared->bindings() → ['active', '2024-01-01'] ``` Advanced Usage -------------- [](#advanced-usage) ``` use JardisSupport\DbQuery\DbQuery; use JardisSupport\DbQuery\DbInsert; // CTE with recursive traversal $cte = (new DbQuery()) ->select('id, parent_id, name, 0 AS depth') ->from('categories') ->where('parent_id')->isNull() ->union( (new DbQuery()) ->select('c.id, c.parent_id, c.name, r.depth + 1') ->from('categories', 'c') ->innerJoin('category_tree', 'c.parent_id = r.id', 'r') ); $query = (new DbQuery()) ->withRecursive('category_tree', $cte) ->select('id, name, depth') ->from('category_tree') ->orderBy('depth') ->orderBy('name'); // Window function for ranking $ranked = (new DbQuery()) ->select('id, customer_id, total') ->selectWindow('ROW_NUMBER', 'row_num') ->over() ->partitionBy('customer_id') ->orderBy('total', 'DESC') ->end() ->from('orders'); // JSON column condition (PostgreSQL) $query = (new DbQuery()) ->select('id, payload') ->from('events') ->whereJson('payload')->path('$.type')->equals('order.created') ->andJson('payload')->path('$.amount')->greaterEquals(100); // INSERT with conflict resolution $insert = (new DbInsert()) ->into('products') ->fields('sku', 'name', 'price') ->values('ABC-001', 'Widget', 9.99) ->onDuplicateKey(['name', 'price']); $sql = $insert->sql('mysql', prepared: true); ``` Documentation ------------- [](#documentation) Full documentation, guides, and API reference: **[docs.jardis.io/en/support/dbquery](https://docs.jardis.io/en/support/dbquery)** License ------- [](#license) This package is licensed under the [MIT License](LICENSE.md). --- **[Jardis](https://jardis.io)** · [Documentation](https://docs.jardis.io) · [Headgent](https://headgent.com) AI-Assisted Development ----------------------- [](#ai-assisted-development) This package ships with a skill for Claude Code, Cursor, Continue, and Aider. Install it in your consuming project: ``` composer require --dev jardis/dev-skills ``` More details: ### Health Score 46 — FairBetter than 92% of packages Maintenance97 Actively maintained with recent releases Popularity16 Limited adoption so far Community13 Small or concentrated contributor base Maturity51 Maturing project, gaining track record Bus Factor1 Top contributor holds 90.9% of commits — single point of failure How is this calculated?**Maintenance (25%)** — Last commit recency, latest release date, and issue-to-star ratio. Uses a 2-year decay window. **Popularity (30%)** — Total and monthly downloads, GitHub stars, and forks. Logarithmic scaling prevents top-heavy scores. **Community (15%)** — Contributors, dependents, forks, watchers, and maintainers. Measures real ecosystem engagement. **Maturity (30%)** — Project age, version count, PHP version support, and release stability. ### Release Activity Cadence Every ~26 days Total 5 Last Release 22d ago ### Community Maintainers ![](https://www.gravatar.com/avatar/e07a1b668e9e01ee6d1b85de7b3be1c2513f68aae9494b2011d1592104d5daa0?d=identicon)[jardis](/maintainers/jardis) --- Top Contributors [![Headgent](https://avatars.githubusercontent.com/u/245725954?v=4)](https://github.com/Headgent "Headgent (10 commits)")[![dependabot[bot]](https://avatars.githubusercontent.com/in/29110?v=4)](https://github.com/dependabot[bot] "dependabot[bot] (1 commits)") --- Tags domain-driven-designjardisphpquery-buildersqlsql-builderphpdatabasesqlpdoqueryDomain Driven Designquery builderhexagonal-architectureSQL BuilderHeadgentjardisjardisSupport ### Code Quality TestsPHPUnit Static AnalysisPHPStan Code StylePHP\_CodeSniffer Type Coverage Yes ### Embed Badge ![Health badge](/badges/jardissupport-dbquery/health.svg) ``` [![Health](https://phpackages.com/badges/jardissupport-dbquery/health.svg)](https://phpackages.com/packages/jardissupport-dbquery) ``` ### Alternatives [clouddueling/mysqldump-php PHP version of mysqldump cli that comes with MySQL 1.3k23.2k](/packages/clouddueling-mysqldump-php) PHPackages © 2026 [Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)