CriticalGHSA-38fc-9xqv-7f7qCVE-2019-7548PYSEC-2019-124

SQLAlchemy is vulnerable to SQL Injection via group_by parameter

Published 16 Apr 2019 · Updated 28 Oct 2024

Is your project on an affected sqlalchemy?

Private repo? Upload its lockfile instead, or connect GitHub to check every repo.

Look after several Python apps? Indie watches up to 15 repos, private ones too, for $5 a month. See Indie

Affected package

Affected
<1.2.19
Fixed in
1.2.19
Update to the fixed version for your release line, for example:pip install 'sqlalchemy>=1.2.19'

Details

SQLAlchemy 1.2.17 has SQL Injection when the group_by parameter can be controlled.

Is GHSA-38fc-9xqv-7f7q in any of your client repos?

Checking one package by hand is fine. Checking it across forty client projects is not. NPMscan reads the lockfiles in every GitHub repo you pick, finds each project with an affected sqlalchemy, and gives you the command that fixes it.

More advisories for sqlalchemy

  • CriticalCVE-2012-0805SQLAlchemy vulnerable to SQL injection · 14 May 2022
  • CriticalCVE-2019-7164SQLAlchemy vulnerable to SQL Injection via order_by parameter · 16 Apr 2019
sqlalchemy security overview

References

Advisory data from OSV.dev (opens OSV.dev in a new tab), refreshed daily.