PHPackages                             tsukasa/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. tsukasa/query\_builder

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

tsukasa/query\_builder
======================

0.1(7y ago)0271MITPHP

Since Jan 6Pushed 6y ago2 watchersCompare

[ Source](https://github.com/tsukasa-mixer/QueryBuilder)[ Packagist](https://packagist.org/packages/tsukasa/query_builder)[ RSS](/packages/tsukasa-query-builder/feed)WikiDiscussions master Synced 3d ago

READMEChangelogDependencies (3)Versions (2)Used By (0)

[![Latest Stable Version](https://camo.githubusercontent.com/8779d1506e61e89e2dd8b5fa109ed1c5d0a02f71775c8fccfdb99f2b204990b9/68747470733a2f2f706f7365722e707567782e6f72672f7473756b6173612f71756572795f6275696c6465722f762f737461626c65)](https://packagist.org/packages/tsukasa/query_builder)[![Total Downloads](https://camo.githubusercontent.com/5985c42475e4a91475d68f539b31d77e4432396e7aebab756618622faadd5af3/68747470733a2f2f706f7365722e707567782e6f72672f7473756b6173612f71756572795f6275696c6465722f646f776e6c6f616473)](https://packagist.org/packages/tsukasa/query_builder)[![Build](https://camo.githubusercontent.com/49bf2df435a66ab98fba2006450eb83f5661b3555ed5e9589c78135d6861d953/68747470733a2f2f7472617669732d63692e6f72672f7473756b6173612d6d697865722f51756572794275696c6465722e7376673f6272616e63683d6d6173746572)](https://travis-ci.org/tsukasa-mixer/QueryBuilder)[![Coverage Status](https://camo.githubusercontent.com/bc230f3324e4bf8bb39e4ee2eb162eb6aa05a0bc9b52cc046935e09764534d27/68747470733a2f2f636f766572616c6c732e696f2f7265706f732f6769746875622f7473756b6173612d6d697865722f51756572794275696c6465722f62616467652e737667)](https://coveralls.io/github/tsukasa-mixer/QueryBuilder)[![Code Intelligence Status](https://camo.githubusercontent.com/e3ff93b32e94fc13844c790b8e99a6704d7cfa24c3a27e2968528e99430e4b7f/68747470733a2f2f7363727574696e697a65722d63692e636f6d2f672f7473756b6173612d6d697865722f51756572794275696c6465722f6261646765732f636f64652d696e74656c6c6967656e63652e7376673f623d6d6173746572)](https://scrutinizer-ci.com/code-intelligence)[![Scrutinizer Code Quality](https://camo.githubusercontent.com/c0b0f94ab87fb33829114423b3e98d8d1b7217530b90c1d537faea1985ad0082/68747470733a2f2f7363727574696e697a65722d63692e636f6d2f672f7473756b6173612d6d697865722f51756572794275696c6465722f6261646765732f7175616c6974792d73636f72652e706e673f623d6d6173746572)](https://scrutinizer-ci.com/g/tsukasa-mixer/QueryBuilder/?branch=master)

- **Subject:** SQL Query builder
- **Syntax:** Django-like lookups
- **Documentation:** **[Russian](./doc/ru/readme.md)**
- **PHP version:** 5.6+
- **Composer:** `composer require tsukasa/query_builder`
- **Packagist:**[tsukasa/QueryBuilder](https://packagist.org/packages/tsukasa/query_builder)
- **License:** [![License](https://camo.githubusercontent.com/3663bce791ea8f2091d5c526bd3f6735ffb160ed3257114122cec0585fca1101/68747470733a2f2f706f7365722e707567782e6f72672f7473756b6173612f71756572795f6275696c6465722f6c6963656e7365)](https://github.com/tsukasa/query_builder) [![FOSSA Status](https://camo.githubusercontent.com/ab20acb94a2f8d5aaca8bba59f73c381a98ef419e402c11632604ec0889d3df1/68747470733a2f2f6170702e666f7373612e696f2f6170692f70726f6a656374732f6769742532426769746875622e636f6d2532467473756b6173612d6d6978657225324651756572794275696c6465722e7376673f747970653d736869656c64)](https://app.fossa.io/projects/git%2Bgithub.com%2Ftsukasa-mixer%2FQueryBuilder?ref=badge_shield)

Basic usage
===========

[](#basic-usage)

```
use Tsukasa\QueryBuilder\QueryBuilder

require('vendor/autoload.php'); // Composer autoloader

$connection = DriverManager::getConnection([
        'dbname' => 'mydb',
        'user' => 'user',
        'password' => 'secret',
        'host' => 'localhost',
        'driver' => 'pdo_mysql',
    ],
    $config = new \Doctrine\DBAL\Configuration()
);

$qb = QueryBuilder::getInstance($connection);
$qb->setTypeSelect()
    ->setSelect('*')
    ->setFrom('comment')
    ->setWhere(['id__gte' => 1])
    ->setOrder(['created_at']);

$connection->fetchAll($qb->toSQL());
// SELECT * FROM comment WHERE id >= 1 ORDER BY created_at ASC
```

###  Health Score

24

—

LowBetter than 32% of packages

Maintenance20

Infrequent updates — may be unmaintained

Popularity8

Limited adoption so far

Community12

Small or concentrated contributor base

Maturity50

Maturing project, gaining track record

 Bus Factor1

Top contributor holds 91.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

Unknown

Total

1

Last Release

2686d ago

### Community

Maintainers

![](https://www.gravatar.com/avatar/59ffc7211e4eac5503c0dbdd9b9e4a0a84b37182117feb9e8c4e2f77ba59e631?d=identicon)[tsukasa-mixer](/maintainers/tsukasa-mixer)

---

Top Contributors

[![tsukasa-mixer](https://avatars.githubusercontent.com/u/1190435?v=4)](https://github.com/tsukasa-mixer "tsukasa-mixer (34 commits)")[![scrutinizer-auto-fixer](https://avatars.githubusercontent.com/u/6253494?v=4)](https://github.com/scrutinizer-auto-fixer "scrutinizer-auto-fixer (2 commits)")[![fossabot](https://avatars.githubusercontent.com/u/29791463?v=4)](https://github.com/fossabot "fossabot (1 commits)")

###  Code Quality

TestsPHPUnit

### Embed Badge

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

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

###  Alternatives

[scienta/doctrine-json-functions

A set of extensions to Doctrine that add support for json query functions.

58523.9M36](/packages/scienta-doctrine-json-functions)[martin-georgiev/postgresql-for-doctrine

Extends Doctrine with native PostgreSQL support for arrays, JSONB, ranges, PostGIS geometries, text search, ltree, uuid, and 100+ PostgreSQL-specific functions.

4485.3M4](/packages/martin-georgiev-postgresql-for-doctrine)[damienharper/auditor-bundle

Integrate auditor library in your Symfony projects.

4542.8M](/packages/damienharper-auditor-bundle)[sonata-project/entity-audit-bundle

Audit for Doctrine Entities

644989.8k1](/packages/sonata-project-entity-audit-bundle)[overtrue/laravel-versionable

Make Laravel model versionable.

585308.0k5](/packages/overtrue-laravel-versionable)[worksome/foggy

Foggy is a tool for making database dumps with some data removed/changed.

26571.7k1](/packages/worksome-foggy)

PHPackages © 2026

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