Download the PHP package andrew-gos/query-builder without Composer
On this page you can find all versions of the php package andrew-gos/query-builder. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Table of contents
Download andrew-gos/query-builder
More information about andrew-gos/query-builder
Files in andrew-gos/query-builder
Download andrew-gos/query-builder
More information about andrew-gos/query-builder
Files in andrew-gos/query-builder
Vendor andrew-gos
Package query-builder
Short Description QueryBuilder
License MIT
Homepage https://github.com/CiBeRHeMuL/QueryBuilder
Package query-builder
Short Description QueryBuilder
License MIT
Homepage https://github.com/CiBeRHeMuL/QueryBuilder
Please rate this library. Is it a good library?
Informations about the package query-builder
QueryBuilder — Fluent SQL Query Builder for PHP 8.5
A lightweight, fluent SQL query builder with multi-dialect support (ANSI, MySQL, PostgreSQL) and an extensible expression system. Write complex SQL queries programmatically without string concatenation.
Quick Start
Features
| Feature | Status |
|---|---|
| SELECT, INSERT, UPDATE, DELETE, VALUES queries | ✅ |
| WHERE, HAVING, GROUP BY, ORDER BY, LIMIT / OFFSET | ✅ |
| JOIN (INNER, LEFT, RIGHT, FULL, CROSS, NATURAL variants) | ✅ |
| Window functions (OVER, PARTITION BY, frame specs) | ✅ |
| Common Table Expressions (WITH, WITH RECURSIVE) | ✅ |
| PostgreSQL: MATERIALIZED CTE, SEARCH / CYCLE | ✅ |
| Set operations: UNION, INTERSECT, EXCEPT (ALL / DISTINCT) | ✅ |
| Row-level locking (FOR UPDATE / FOR SHARE, NOWAIT / SKIP LOCKED) | ✅ |
| MySQL: HIGH_PRIORITY, STRAIGHTJOIN, SQL* hints, PARTITION | ✅ |
| PostgreSQL: DISTINCT ON, ONLY modifier, RETURNING, ON CONFLICT | ✅ |
| Named parameter binding with auto-generated IDs | ✅ |
| MERGE query | ✅ |
| PostgreSQL: MERGE RETURNING, DO NOTHING | ✅ |
| Additional SQL dialects | 🚧 In development |
Documentation
- Quick Start Guide — Installation, first query, architecture overview.
- Query Types — Full reference for SELECT, INSERT, UPDATE, DELETE, VALUES, MERGE.
- Expressions — Expression system, ValueBuilder, conditions, windows, CTEs.
- Dialects — Default/ANSI, MySQL, and PostgreSQL grammar specifics.
Requirements
- PHP 8.5+
andrew-gos/helpers^1.0
Installation
Roadmap
- v1.2.0 — Additional SQL dialects (SQLite, MariaDB)
License
This library is open-source software licensed under the MIT License.
All versions of query-builder with dependencies
PHP Build Version
Package Version
The package andrew-gos/query-builder contains the following files
Loading the files please wait ...