CVE-2026-104129

GHSA-v9v2-98xq-627c · published 19 Nov 2026 · updated 20 Nov 2026

pREST _groupby function-expression SQL injection (incomplete fix of CVE-2025-58450)

8.1HighCVSS 8.1EPSS 0%

No exploitation in the wild has been reported. EPSS puts the chance of exploitation in the next 30 days at 0%. Fixed in github.com/prest/prest/v2 2.4.0.

pREST (PostgreSQL REST) is an API that delivers an application on top of a Postgres database. Prior to 2.4.0, the vulnerable parameter is _groupby, handled by GroupByClause in adapters/postgres/postgres.go. adapters/postgres/postgres.go uses the weaker isSafeSQLExpression check for this function-expression branch instead of the stricter single-field validator used for _select. That check validates only the outer function name against a 13-function allowlist and permits nested subqueries, trailing UNION syntax, and inner pg_ functions. controllers/crud.go concatenates the GROUP BY expression while parameterizing only WHERE values, allowing attacker-controlled SQL structure into the clause. Default configuration permits unauthenticated access; a restricted installation may require a low-privilege table reader. UNION-based extraction requires compatible column counts and types and was not verified end to end, but a delay-producing function can cause denial of service without that alignment. This issue is fixed in 2.4.0.

Affected

Vendors, products and packages with version ranges

VendorProductVersionsFixed
prest<2.4.0
go: github.com/prest/prest<=1.5.5
go: github.com/prest/prest/v2<2.4.0, <=2.3.02.4.0

Timeline

Every event on this vulnerability

Embed

A live severity badge for an advisory, README or ticket

CVE-2026-104129 severity on Zeptric[![CVE-2026-104129](https://zeptric.io/badge/cve/CVE-2026-104129.svg)](https://zeptric.io/cve/CVE-2026-104129)