PostgreSQL: pg_builder 2.1.0 released with support for Postgres 15 syntax

[NewsBot]

A new PostgreSQL blog post/announcement has been posted!

I'm pleased to announce the release of pg_builder PHP package updated for Postgres 15 syntax.

pg_builder 2.1.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 15 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.

Main changes in the new release

• Allow parsing and building MERGE statements.
• Reject numeric literals and positional parameters with trailing non-digits: previously SELECT 123abc</c...

Get the full details here: PostgreSQL: pg_builder 2.1.0 released with support for Postgres 15 syntax