PHPackages                             andrew-gos/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. andrew-gos/query-builder

ActiveLibrary[Database & ORM](/categories/database)

andrew-gos/query-builder
========================

QueryBuilder

v1.1.0(yesterday)10MITPHPPHP ^8.5CI passing

Since Jun 4Pushed yesterdayCompare

[ Source](https://github.com/CiBeRHeMuL/QueryBuilder)[ Packagist](https://packagist.org/packages/andrew-gos/query-builder)[ Docs](https://github.com/CiBeRHeMuL/QueryBuilder)[ RSS](/packages/andrew-gos-query-builder/feed)WikiDiscussions main Synced yesterday

READMEChangelog (3)Dependencies (3)Versions (4)Used By (0)

QueryBuilder — Fluent SQL Query Builder for PHP 8.5
===================================================

[](#querybuilder--fluent-sql-query-builder-for-php-85)

[![CI](https://github.com/CiBeRHeMuL/QueryBuilder/actions/workflows/ci.yml/badge.svg)](https://github.com/CiBeRHeMuL/QueryBuilder/actions/workflows/ci.yml)[![Latest Stable Version](https://camo.githubusercontent.com/72c836b692d0feacf53a0afdbb69c74647a417e1706b7e967fe6d794c25befe9/68747470733a2f2f706f7365722e707567782e6f72672f616e647265772d676f732f71756572792d6275696c6465722f76657273696f6e2e737667)](https://packagist.org/packages/andrew-gos/query-builder)[![Latest Unstable Version](https://camo.githubusercontent.com/698c833439adb529f8494c2fbee6576faeccce9eae5463811b349f1adef758ab/68747470733a2f2f706f7365722e707567782e6f72672f616e647265772d676f732f71756572792d6275696c6465722f762f756e737461626c652e737667)](https://packagist.org/packages/andrew-gos/query-builder)[![PHP Version](https://camo.githubusercontent.com/3388dd99f51454790b4942bf2837f8fdb472dfee7017722f0f60f5da4fc0508c/68747470733a2f2f706f7365722e707567782e6f72672f616e647265772d676f732f71756572792d6275696c6465722f726571756972652f706870)](https://packagist.org/packages/andrew-gos/query-builder)[![License](https://camo.githubusercontent.com/0d199be8f4a71c2c00dfa4b5980a8745ae79a29a5466c78a31b27f1a7e61aa65/68747470733a2f2f706f7365722e707567782e6f72672f616e647265772d676f732f71756572792d6275696c6465722f6c6963656e73652e737667)](https://packagist.org/packages/andrew-gos/query-builder)[![Total Downloads](https://camo.githubusercontent.com/bdd8e57e34698259c61d211cd8f3496c59961a1dd8eb9d551534ed249c927c21/68747470733a2f2f706f7365722e707567782e6f72672f616e647265772d676f732f71756572792d6275696c6465722f642f746f74616c2e737667)](https://packagist.org/packages/andrew-gos/query-builder)[![Codecov](https://camo.githubusercontent.com/5f542ecaa394fe724ed1b0ddc94fa85609be1990f2d0905ccd49e60fdeca2ca2/68747470733a2f2f636f6465636f762e696f2f6769746875622f436942655248654d754c2f51756572794275696c6465722f67726170682f62616467652e737667)](https://codecov.io/github/CiBeRHeMuL/QueryBuilder)

A lightweight, fluent SQL query builder with multi-dialect support (ANSI, MySQL, PostgreSQL) and an extensible expression system. Write complex SQL queries programmatically without string concatenation.

---

Quick Start
-----------

[](#quick-start)

```
use AndrewGos\QueryBuilder\Grammar\DefaultGrammar;
use AndrewGos\QueryBuilder\Query\Select\SelectQuery;

$grammar = new DefaultGrammar();
$query = (new SelectQuery())
    ->select(['id', 'name', 'email'])
    ->from(['users'])
    ->where(['active' => true]);

$built = $grammar->buildSelectQuery($query);
echo $built->sql;    // SELECT "id", "name", "email" FROM "users" WHERE "active" IS TRUE
print_r($built->params);  // []
```

---

Features
--------

[](#features)

FeatureStatusSELECT, INSERT, UPDATE, DELETE, VALUES queries✅WHERE, HAVING, GROUP BY, ORDER BY, LIMIT / OFFSET✅JOIN (INNER, LEFT, RIGHT, FULL, CROSS, NATURAL variants)✅Window functions (OVER, PARTITION BY, frame specs)✅Common Table Expressions (WITH, WITH RECURSIVE)✅PostgreSQL: MATERIALIZED CTE, SEARCH / CYCLE✅Set operations: UNION, INTERSECT, EXCEPT (ALL / DISTINCT)✅Row-level locking (FOR UPDATE / FOR SHARE, NOWAIT / SKIP LOCKED)✅MySQL: HIGH\_PRIORITY, STRAIGHT\_JOIN, SQL\_\* hints, PARTITION✅PostgreSQL: DISTINCT ON, ONLY modifier, RETURNING, ON CONFLICT✅Named parameter binding with auto-generated IDs✅MERGE query🚧 In developmentAdditional SQL dialects🚧 In development---

Documentation
-------------

[](#documentation)

- [Quick Start Guide](docs/quick-start.md) — Installation, first query, architecture overview.
- [Query Types](docs/query-types.md) — Full reference for SELECT, INSERT, UPDATE, DELETE, VALUES.
- [Expressions](docs/expressions.md) — Expression system, ValueBuilder, conditions, windows, CTEs.
- [Dialects](docs/dialects.md) — Default/ANSI, MySQL, and PostgreSQL grammar specifics.

---

Requirements
------------

[](#requirements)

- PHP 8.5+
- `andrew-gos/helpers` ^1.0

---

Installation
------------

[](#installation)

```
composer require andrew-gos/query-builder
```

---

Roadmap
-------

[](#roadmap)

- **v1.1.0** — MERGE query support
- **v1.2.0** — Additional SQL dialects (SQLite, MariaDB)

---

License
-------

[](#license)

This library is open-source software licensed under the [MIT License](LICENSE).

###  Health Score

42

—

FairBetter than 88% of packages

Maintenance100

Actively maintained with recent releases

Popularity2

Limited adoption so far

Community2

Small or concentrated contributor base

Maturity53

Maturing project, gaining track record

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 ~2 days

Total

3

Last Release

1d ago

### Community

Maintainers

![](https://www.gravatar.com/avatar/4b8138927f33d6978608e73d01f2c42ef975bacd471c0b3235420beffcd21c90?d=identicon)[Andrew\_gos](/maintainers/Andrew_gos)

---

Tags

phpdbquery builderandrew-gos

###  Code Quality

TestsPHPUnit

Code StylePHP CS Fixer

### Embed Badge

![Health badge](/badges/andrew-gos-query-builder/health.svg)

```
[![Health](https://phpackages.com/badges/andrew-gos-query-builder/health.svg)](https://phpackages.com/packages/andrew-gos-query-builder)
```

###  Alternatives

[stefangabos/zebra_database

An advanced, compact and lightweight MySQL database wrapper library, built around PHP's MySQLi extension.

11712.4k](/packages/stefangabos-zebra-database)[matchory/elasticsearch

The missing elasticsearch ORM for Laravel!

3061.7k](/packages/matchory-elasticsearch)[soosyze/queryflatfile

The Queryflatfile is PHP library for simple database not SQL

181.1k1](/packages/soosyze-queryflatfile)[simple-swoole/db

A db component for Simps.

216.6k3](/packages/simple-swoole-db)[hemiframe/php-query-builder

Powerful and lightweight PHP SQL Query Builder

1120.9k](/packages/hemiframe-php-query-builder)

PHPackages © 2026

[Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)