Skip to content

Releases: Flowpack/query-object-builder

Release list

v0.2.0

Choose a tag to compare

@hlubek hlubek released this 01 Jul 17:27
403f230

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

Choose a tag to compare

@hlubek hlubek released this 29 Jun 08:52

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.