QBuilder is a PHP library that builds SQL query strings through a fluent API for MySQL/MariaDB, PostgreSQL, ClickHouse, MS SQL Server, Oracle and SQLite. It generates SQL only and does not open connections or execute queries.
- SELECT, INSERT, UPDATE, DELETE queries
- WHERE and HAVING conditions with nested groups
- JOINs, subqueries, aggregates, UNION, recursive CTEs
- Two syntaxes: method chaining and closures
- Testo test suite, PHPStan at max level with strict rules
composer require alekvolsk/qbuilder- PHP >= 8.4
use QBuilder\QbConsts;
use QBuilder\QueryBuilder;
$sql = (new QueryBuilder(QbConsts::DRIVER_PDO_MYSQL))
->select('id', 'name', 'email')
->from('users')
->where()
->eq('status', 'active')
->end()
->build(true);
// SELECT `id`, `name`, `email` FROM `users` WHERE (`status` = 'active')See CONTRIBUTING.md.