Skip to content
AlekVolskPublic

About

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.

Topics

Resources

Contributing

Stars

0 stars

Watchers

0 watching

Forks

Repository files navigation

QBuilder - SQL Query Builder

License: MIT PHP Version

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

Installation

composer require alekvolsk/qbuilder

Requirements

  • PHP >= 8.4

Quick Start

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')

Documentation

Contributing

See CONTRIBUTING.md.

License

MIT

About

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.

Topics

Resources

Contributing

Stars

0 stars

Watchers

0 watching

Forks

Releases

Packages

Contributors

Languages