pREST _groupby function-expression SQL injection (incomplete fix of CVE-2025-58450)
Default status is the baseline for the product, each version can override it (e.g. patched versions marked unaffected).
| Vendor | Product | Default status | Versions | ||||||
|---|---|---|---|---|---|---|---|---|---|
| prest | prest | affected |
|
No data.
No data.
| Vendor | Product | Versions | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|
| Prest | Prest |
|
| Source | ID | Title |
|---|---|---|
Github GHSA |
GHSA-v9v2-98xq-627c | pREST _groupby function-expression SQL injection (incomplete fix of CVE-2025-58450) |
No CVSS v4.0
No CVSS v3.0
No CVSS v2
This CVE is not in the KEV list.
Exploit prediction score: < 1% (0.431% probability within 30 days)
| Type | Values Removed | Values Added |
|---|---|---|
| Metrics |
ssvc
|
| Type | Values Removed | Values Added |
|---|---|---|
| First Time appeared |
Prest
Prest prest |
|
| Vendors & Products |
Prest
Prest prest |
| Type | Values Removed | Values Added |
|---|---|---|
| Description | 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. | |
| Title | pREST _groupby function-expression SQL injection (incomplete fix of CVE-2025-58450) | |
| Weaknesses | CWE-89 | |
| References |
|
|
| Metrics |
cvssV3_1
|