PHPackages kekos/query-builder - 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. kekos/query-builder ActiveLibrary[Database & ORM](/categories/database) kekos/query-builder =================== Small SQL query builder v2.2.2(7mo ago)111.3k↓41.2%1MITPHPPHP ~8.1.0 || ~8.2.0 || ~8.3.0 || ~8.4.0CI passing Since Dec 7Pushed 7mo ago1 watchersCompare [ Source](https://github.com/Kekos/query-builder)[ Packagist](https://packagist.org/packages/kekos/query-builder)[ Docs](https://github.com/Kekos/query-builder)[ RSS](/packages/kekos-query-builder/feed)WikiDiscussions master Synced 1mo ago READMEChangelog (6)Dependencies (3)Versions (25)Used By (0) Query Builder for PHP ===================== [](#query-builder-for-php) A fork of [Muhammad Usman's Pixie](https://github.com/usmanhalalit/pixie), a lightweight query builder for PHP. This library only supports a subset of Pixie's fetures: - Nested criterias (`WHERE`, `HAVING` and `ON` for joins) - Raw queries Query Builder is not able to open database connections or execute the built queries. Install ------- [](#install) You can install Query Builder via [Composer](http://getcomposer.org/): ``` composer require kekos/query-builder ``` API --- [](#api) Start by configure Query Builder with an adapter: ``` QueryBuilder::setAdapter(new MySqlAdapter()); ``` The adapter sets the correct sanitizer character. At this moment `MySqlAdapter` is provided with the library. All builders have a `toSql()` method, which returns the SQL query and all parameters to be bound to the query, to be used with prepared statements. ### Select [](#select) ``` $result = QueryBuilder::select(['user', 'u']) ->columns(['u.id', 'uname' => 'username']) ->joinOn(['user_permission', 'p'], 'p.user_id', 'u.id') ->limit(5, 0) ->groupby(['u.id']) ->orderby(['username ASC', 'firstname ASC']) ->where('firstname', '=', 'Christoffer') ->whereNot('u.id', 'IN', array(2)) ->toSql(); ``` `$result` will be an object of type `QueryBuilder\QueryBuilders\Raw`. #### Nested `where` or `having` [](#nested-where-or-having) ``` $result = QueryBuilder::select('user') ->orderby('id') ->where(function($qb) { $qb->where('name', 'LIKE', '%chris%') ->whereOr('username', 'LIKE', '%chris%'); }) ->where('active', '=', 1) ->toSql(); ``` ### Insert [](#insert) ``` $result = QueryBuilder::insert('user') ->values([ 'username' => 'Kekos', 'firstname' => 'Christoffer' ]) ->toSql(); ``` ### Update [](#update) ``` $result = QueryBuilder::update('user') ->set([ 'username' => 'new_username', 'firstname' => 'New firstname' ]) ->where('id', '=', 2) ->toSql(); ``` ### Delete [](#delete) ``` $result = QueryBuilder::delete('user') ->where('id', '=', 2) ->toSql(); ``` Bugs and improvements --------------------- [](#bugs-and-improvements) Report bugs in GitHub issues or feel free to make a pull request :-) License ------- [](#license) MIT ### Health Score 52 — FairBetter than 96% of packages Maintenance63 Regular maintenance activity Popularity28 Limited adoption so far Community8 Small or concentrated contributor base Maturity90 Battle-tested with a long release history Bus Factor1 Top contributor holds 100% 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 ~156 days Recently: every ~0 days Total 24 Last Release 224d ago Major Versions v1.2.1 → v2.0.02018-09-22 v1.7.2 → v2.1.02025-06-11 v1.8.0 → v2.2.02025-06-24 v1.8.2 → v2.2.12025-10-06 v1.8.3 → v2.2.22025-10-06 PHP version history (5 changes)v1.0.0PHP >= 5.3.0 v2.0.0PHP >= 7.1.0 v1.3.0PHP >= 5.4.0 v1.8.0PHP ~5.6.0 v2.2.0PHP ~8.1.0 || ~8.2.0 || ~8.3.0 || ~8.4.0 ### Community Maintainers ![](https://www.gravatar.com/avatar/d95792c940b68df0577eaf918c0529b60f5b831a9a0bc093e306c581bc52c660?d=identicon)[Kekos](/maintainers/Kekos) --- Top Contributors [![Kekos](https://avatars.githubusercontent.com/u/914782?v=4)](https://github.com/Kekos "Kekos (73 commits)") --- Tags databasesqlpdoquerybuilder ### Code Quality TestsPHPUnit Static AnalysisPHPStan Type Coverage Yes ### Embed Badge ![Health badge](/badges/kekos-query-builder/health.svg) ``` [![Health](https://phpackages.com/badges/kekos-query-builder/health.svg)](https://phpackages.com/packages/kekos-query-builder) ``` ### Alternatives [aura/sqlquery Object-oriented query builders for MySQL, Postgres, SQLite, and SQLServer; can be used with any database connection library. 4572.9M34](/packages/aura-sqlquery)[envms/fluentpdo FluentPDO is a quick and light PHP library for rapid query building. It features a smart join builder, which automatically creates table joins. 925511.7k13](/packages/envms-fluentpdo)[lichtner/fluentpdo FluentPDO is a quick and light PHP library for rapid query building. It features a smart join builder, which automatically creates table joins. 921274.8k6](/packages/lichtner-fluentpdo)[fpdo/fluentpdo FluentPDO is a quick and light PHP library for rapid query building. It features a smart join builder, which automatically creates table joins. 921244.9k7](/packages/fpdo-fluentpdo)[izniburak/pdox Useful Query Builder, PDO Class for PHP. A simple access to your SQL records. 30221.1k7](/packages/izniburak-pdox)[atlas/query Object-oriented query builders and performers for MySQL, Postgres, SQLite, and SQLServer. 41249.0k7](/packages/atlas-query) PHPackages © 2026 [Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)