Releases: Flowpack/query-object-builder
Releases · Flowpack/query-object-builder
Release list
v0.2.0
MySQL & MariaDB query builder
Adds a new MySQL\Q facade — a single fluent, immutable builder covering both
MySQL 8.4 and MariaDB 11.x. Rendering is fully determined by construction, not a
dialect flag.
Highlights
- Full SELECT family: joins, CTEs (
WITH), window functions, grouping, ordering,
and the JSON selection shape. - INSERT / UPDATE / DELETE / REPLACE, including
ON DUPLICATE KEY UPDATE. - MySQL-native expression surface:
<=>, the->/->>JSON operators, and the
JSON function set (JSON_TABLE,JSON_CONTAINS, …). - Engine-divergent constructs are validated on an opt-in pass —
Q::build($q)->withValidateTarget(Target::mysql() | Target::mariaDb())reports
what the target can't express (version-gated where relevant, e.g. MariaDB-only
RETURNING).
Also — additional PostgreSQL builder tests and coverage.
Full changelog: v0.1.0...v0.2.0
v0.1.0
First release of the query object builder for fully typed, complex SQL queries.
In this version we focused on a port from https://github.com/networkteam/qrb and implement the PostgreSQL builder and dialect.
Important: Expect the API to change slightly until we settle the PHP shape.