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

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

blues911/query-builder
======================

PDO wrapper for building native SQL queries.

0.2.0(3y ago)08MITPHPPHP >=7.4

Since Mar 23Pushed 3y ago1 watchersCompare

[ Source](https://github.com/blues911/query-builder)[ Packagist](https://packagist.org/packages/blues911/query-builder)[ Docs](https://github.com/blues911/query-builder)[ RSS](/packages/blues911-query-builder/feed)WikiDiscussions master Synced 1w ago

READMEChangelogDependencies (1)Versions (4)Used By (0)

Query Builder
=============

[](#query-builder)

[![Build Status](https://camo.githubusercontent.com/f9d7e5233b1fa933ccb698e7e7267385ed7dd0e3dc4c390acfe37de3776e5e1e/68747470733a2f2f7472617669732d63692e636f6d2f626c7565733931312f71756572792d6275696c6465722e7376673f6272616e63683d6d6173746572)](https://travis-ci.com/blues911/query-builder)

PDO wrapper for building native SQL queries.

> This package does not follow to the best practice or something similar. It was developed for a testing purpose to build quick and dirty SQL queries.

Install
-------

[](#install)

```
composer require blues911/query-builder

```

Example
-------

[](#example)

Usage:

```
require('vendor/autoload.php');

use QueryBuilder\Builder as DB;

// init connection
$db = new DB([
    'mysql:dbname=test;host=localhost;port=3306;charset=utf8',
    'root',
    'password'
]);

// query all
$db->query("SELECT * FROM users")
    ->build()
    ->fetchAll();

// query one
$db->query("SELECT * FROM users WHERE id=:id")
    ->bindParams(['id', 1])
    ->build()
    ->fetch();

// count
$db->query("SELECT * FROM users")
    ->build()
    ->rowCount();

// debug params
$db->query("SELECT * FROM users WHERE status=:status AND role=:role")
    ->bindParams([
        ['status', 1],
        ['role', 'admin']
    ])
    ->build()
    ->debugParams();
```

Parameters binding:

```
// array
->bindParams(['key1', 'value1']);
->bindParams(['key2', 'value2']);

// multidimensional array
->bindParams([
    ['key1', 'value1'],
    ['key2', 'value2']
]);
```

Fetch result:

```
// object
->fetch();
->fetchAll();

// array
->fetch(true);
->fetchAll(true);
```

[PDO Statement](https://www.php.net/manual/en/class.pdo.php) available via direct call:

```
$db->errorCode();
$db->errorInfo();
$db->getAvailableDrivers();
```

###  Health Score

20

—

LowBetter than 14% of packages

Maintenance20

Infrequent updates — may be unmaintained

Popularity4

Limited adoption so far

Community4

Small or concentrated contributor base

Maturity44

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

Total

3

Last Release

1229d ago

PHP version history (3 changes)0.1.0PHP >=5.6.0

0.1.1PHP ^7.0

0.2.0PHP >=7.4

### Community

Maintainers

![](https://www.gravatar.com/avatar/2e84d0e9910177ce246c37e8e91c658022da044ad205630bfb177086b15ea73c?d=identicon)[blues911](/maintainers/blues911)

---

Tags

pdoquery-builderpdoquery builder

###  Code Quality

TestsPHPUnit

### Embed Badge

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

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

###  Alternatives

[tommyknocker/pdo-database-class

Framework-agnostic PHP database library with unified API for MySQL, MariaDB, PostgreSQL, SQLite, MSSQL, and Oracle. Query Builder, caching, sharding, window functions, CTEs, JSON, migrations, ActiveRecord, CLI tools, AI-powered analysis. Zero external dependencies.

845.7k](/packages/tommyknocker-pdo-database-class)[codesvault/howdy-qb

Mysql Query Builder for WordPress

371.2k1](/packages/codesvault-howdy-qb)

PHPackages © 2026

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