Improper Neutralization of Special Elements used in an SQL Command ('SQL Injection') Affecting piccolo package, versions [,1.1.1)


Severity

Recommended
0.0
critical
0
10

CVSS assessment made by Snyk's Security Team. Learn more

Threat Intelligence

Exploit Maturity
Proof of concept
EPSS
0.16% (54th percentile)

Do your applications use this vulnerable package?

In a few clicks we can analyze your entire application and see what components are vulnerable in your application, and suggest you quick fixes.

Test your applications
  • Snyk IDSNYK-PYTHON-PICCOLO-6056140
  • published12 Nov 2023
  • disclosed10 Nov 2023
  • creditSkelmis Ethan

Introduced: 10 Nov 2023

CVE-2023-47128  (opens in a new tab)
CWE-89  (opens in a new tab)

How to fix?

Upgrade piccolo to version 1.1.1 or higher.

Overview

piccolo is an A fast, user friendly ORM and query builder which supports asyncio.

Affected versions of this package are vulnerable to Improper Neutralization of Special Elements used in an SQL Command ('SQL Injection') in the handling of named transaction savepoints in all database implementations, when a provided input is passed directly to connection.execute(...) via f-strings.

References

CVSS Scores

version 3.1