========================================================================
CVE-2026-121007                                      CPAN Security Group
========================================================================

         CVE ID:  CVE-2026-121007

   Distribution:  SQL-Abstract
       Versions:  from 1.90_01 before 2.000001_04
       MetaCPAN:  https://metacpan.org/dist/SQL-Abstract
       VCS Repo:  https://github.com/dbsrgits/sql-abstract

SQL::Abstract versions from 1.90_01 before 2.000001_04 for Perl allow
SQL injection via the where values of a nested statement in an
identifier position

Description
-----------
SQL::Abstract versions from 1.90_01 before 2.000001_04 for Perl allow
SQL injection via the where values of a nested statement in an
identifier position.

A nested statement such as { -select => ... } in a position where plain
scalars are identifiers treats its own plain scalars as identifiers
too. These positions are the select list, ORDER BY, GROUP BY,
RETURNING, and with the ExtraClauses plugin FROM (-as) and JOIN (to).
The values of the statement's where, having and set clauses, and the
rows of a -values, go into the SQL text instead of the bind list,
unescaped unless quote_char is set. Subselects in a WHERE condition are
not affected.

An application that passes untrusted input as a where value of such a
nested statement, expecting it to be bound, allows SQL injection.

Problem types
-------------
- CWE-89 Improper Neutralization of Special Elements used in an SQL
   Command ('SQL Injection')

Solutions
---------
Upgrade to SQL-Abstract 2.000001_04 or later.

References
----------
https://github.com/dbsrgits/sql-abstract/commit/79fc34e874b4edb441154eccddb04c57d5c1c90e.patch
https://metacpan.org/release/GETTY/SQL-Abstract-2.000001_04/changes