PostgreSQL: pg_builder and pg_wrapper 3.0 released with support for Postgres 17 syntax

[NewsBot]

A new PostgreSQL blog post/announcement has been posted!

I am pleased to announce the release of pg_builder and pg_wrapper packages for PHP updated for Postgres 17 syntax.

pg_builder 3.0

pg_builder is a query builder for Postgres backed by a partial PHP reimplementation of PostgreSQL's own SQL parser. It supports almost all syntax available in Postgres 17 for SELECT (and VALUES), INSERT, UPDATE, DELETE, and MERGE queries.

With pg_builder it is possible to start with a manually written query, parse it into an Abstract Syntax Tree, add query parts (either as Node objects or as strings) to this tree or remove them, and finally convert the tree back to an SQL string.

Release highlights:

• Support for new syntax of Postgres 17
  • MERGE statement improvements: RETURNING clause, W...

Get the full details here: PostgreSQL: pg_builder and pg_wrapper 3.0 released with support for Postgres 17 syntax