PHPackages                             walnut/lib\_dbquerybuilder - 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. walnut/lib\_dbquerybuilder

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

walnut/lib\_dbquerybuilder
==========================

0.0.4(2y ago)0751PHP

Since Sep 13Pushed 2y ago1 watchersCompare

[ Source](https://github.com/kapitancho/walnut-lib-dbquerybuilder)[ Packagist](https://packagist.org/packages/walnut/lib_dbquerybuilder)[ RSS](/packages/walnut-lib-dbquerybuilder/feed)WikiDiscussions main Synced 1w ago

READMEChangelog (4)Dependencies (2)Versions (5)Used By (1)

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

[](#query-builder)

Lightweight Select, Insert, Update and Delete query builders.

Examples
--------

[](#examples)

### Some common objects:

[](#some-common-objects)

```
$quoter = new MysqlQuoter;

$queryFilter = new QueryFilter(
    new AndExpression(
        new OrExpression(
            new NotExpression(
                new FieldExpression('name', 'LIKE',
                    new SqlValue("%test%"))
            ),
            new FieldExpression('id', '>', new SqlValue(3))
        ),
        new RawExpression("`name` NOT IN ('admin', 'dev')"),
        new FieldExpression('name', '!=', 'id')
    )
);
```

Insert Query:

```
$iqb = new InsertQuery(
    "clients", [
        "id" => new SqlValue(7),
        "name" => new SqlValue('Client 7')
    ]
);
echo $iqb->build($quoter), PHP_EOL;
```

Update Query

```
$uqb = new UpdateQuery(
    "clients", [
        "id" => new PreparedValue('id'),
        "name" => new SqlValue('Client 7')
    ],
    $queryFilter
);
echo $uqb->build($quoter), PHP_EOL;
```

Select Query

```
$sqb = new SelectQuery(
    "clients", [
        "id" => "id",
        "clientName" => "name"
    ],
    [
        new TableJoin("p", "projects", new QueryFilter(
            FieldExpression::equals(
                new TableField("_", "id"),
                new TableField("p", "client_id"),
            )
        ))
    ],
    $queryFilter,
    [
        OrderBy::ascending('id'),
        OrderBy::descending('name')
    ],
    SelectLimit::forPage(3, 20)
);
echo $sqb->build($quoter), PHP_EOL;
```

Delete Query

```
$dqb = new DeleteQuery(
    "clients", $qf
);
echo $dqb->build($quoter), PHP_EOL;
```

###  Health Score

22

—

LowBetter than 22% of packages

Maintenance20

Infrequent updates — may be unmaintained

Popularity9

Limited adoption so far

Community9

Small or concentrated contributor base

Maturity43

Maturing project, gaining track record

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

Total

4

Last Release

847d ago

### Community

Maintainers

![](https://www.gravatar.com/avatar/12d2910601119ce65c373b7e21ffc647154bde10c5ad0a0598ab1143aa851701?d=identicon)[kapitancho](/maintainers/kapitancho)

---

Top Contributors

[![kapitancho](https://avatars.githubusercontent.com/u/792682?v=4)](https://github.com/kapitancho "kapitancho (5 commits)")

###  Code Quality

TestsPHPUnit

Static AnalysisPsalm

Type Coverage Yes

### Embed Badge

![Health badge](/badges/walnut-lib-dbquerybuilder/health.svg)

```
[![Health](https://phpackages.com/badges/walnut-lib-dbquerybuilder/health.svg)](https://phpackages.com/packages/walnut-lib-dbquerybuilder)
```

###  Alternatives

[doctrine/orm

Object-Relational-Mapper for PHP

10.2k285.3M6.2k](/packages/doctrine-orm)[jdorn/sql-formatter

a PHP SQL highlighting library

3.9k115.1M102](/packages/jdorn-sql-formatter)[illuminate/database

The Illuminate Database package.

2.8k52.4M9.4k](/packages/illuminate-database)[mongodb/mongodb

MongoDB driver library

1.6k64.0M546](/packages/mongodb-mongodb)[ramsey/uuid-doctrine

Use ramsey/uuid as a Doctrine field type.

90340.3M211](/packages/ramsey-uuid-doctrine)[reliese/laravel

Reliese Components for Laravel Framework code generation.

1.7k3.4M16](/packages/reliese-laravel)

PHPackages © 2026

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