Download the PHP package abdulelahragih/querybuilder without Composer

QueryBuilder

Fast, lightweight, and simple SQL query builder that does not depend on any third-party library besides PDO to execute the queries in a safe way. The syntax is inspired by Laravel Query Builder.

Features

• Automatic parameter binding via an internal bindings manager.
• Comprehensive WHERE builder: nested groups, IN/NOT IN, LIKE/NOT LIKE, NULL/NOT NULL, BETWEEN/NOT BETWEEN.
• Rich JOINs: INNER, LEFT, RIGHT, and FULL (only on dialects that support it, e.g., PostgreSQL) with nested conditions and on helpers.
• Pagination: paginate (length-aware) and simplePaginate (no total count) with page name support.
• Dialect-aware SQL generation with automatic detection (MySQL & Postgres for now).
• Inserts, updates, deletes with safety checks (no UPDATE/DELETE without WHERE).
• Upserts with dialect-specific behavior.
• Convenience helpers: first, pluck, distinct, orderBy, limit, offset, raw expressions, objectConverter.
• Results as a fluent Collection and paginator objects.

Installation

Install via Composer:

Getting Started

Create a builder from a PDO instance. Dialect is auto-detected from PDO::ATTR_DRIVER_NAME (pgsql → Postgres; otherwise MySQL):

You can also use the thin DB wrapper (instance-based) or the DBSingleton for a static facade if you prefer:

Pagination

Length-aware pagination returns totals and page info:

Simple pagination is lighter weight:

Inserts and Upserts

• Insert single or multiple rows:

• Upsert with a unified API across dialects:

• Do-nothing on conflict (Postgres):

• Insert and get the generated id (Postgres supports RETURNING, MySQL uses lastInsertId):

Updates and Deletes

Both operations require a WHERE clause for safety and return the affected rows count:

WHERE and JOIN Builders

• WHERE helpers: where, orWhere, whereIn, whereNotIn, whereLike, whereNotLike, whereNull, whereNotNull, whereBetween, whereNotBetween, nested closures.
• JOIN helpers: join, leftJoin, rightJoin, fullJoin, plus nested where/orWhere inside join closures and on/orOn for column comparisons.

Examples (WHERE):

Examples (JOIN):

Object Conversion

Map rows to custom objects after fetching:

Transactions (Using the DB Wrapper)

Let the builder handle transactions:

Or manually:

Notes

• Update/Delete without a WHERE clause throws an exception by default.
• insertGetId expects a single row payload.
• Feature set varies slightly by dialect (e.g., Postgres RETURNING, ON CONFLICT ... DO NOTHING).

Contribution

Contributions are welcome!