{"id":"PYSEC-2026-1855","summary":"python-sql SQL injection vulnerability","details":"A vulnerability was found in python-sql where unary operators do not escape non-Expression (like `And` and `Or`) which makes any system exposing those vulnerable to an SQL injection attack.","aliases":["CVE-2024-9774","GHSA-pq9p-pc3p-9hm4"],"modified":"2026-07-07T17:48:08.050310645Z","published":"2026-07-07T14:34:47.930521Z","references":[{"type":"ADVISORY","url":"https://nvd.nist.gov/vuln/detail/CVE-2024-9774"},{"type":"WEB","url":"https://access.redhat.com/security/cve/CVE-2024-9774"},{"type":"WEB","url":"https://bugs.tryton.org/python-sql/93"},{"type":"WEB","url":"https://bugzilla.redhat.com/show_bug.cgi?id=2332734"},{"type":"WEB","url":"https://discuss.tryton.org/t/security-release-for-issue-93/7889"},{"type":"WEB","url":"https://discuss.tryton.org/t/security-release-for-issue-93/7889/3"},{"type":"WEB","url":"https://foss.heptapod.net/tryton/python-sql/-/commit/f20551bbb8b3b4c4dd0a2c3d36f377bff6f2f349"},{"type":"PACKAGE","url":"https://github.com/tryton/python-sql"},{"type":"WEB","url":"https://lists.debian.org/debian-lts-announce/2024/10/msg00023.html"},{"type":"PACKAGE","url":"https://pypi.org/project/python-sql"},{"type":"ADVISORY","url":"https://github.com/advisories/GHSA-pq9p-pc3p-9hm4"}],"affected":[{"package":{"name":"python-sql","ecosystem":"PyPI","purl":"pkg:pypi/python-sql"},"ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"1.5.2"}]}],"versions":["0.1","0.2","0.3","0.4","0.5","0.6","0.7","0.8","0.9","1.0.0","1.1.0","1.2.0","1.2.1","1.2.2","1.3.0","1.4.0","1.4.1","1.4.2","1.4.3","1.5.0","1.5.1"],"database_specific":{"source":"https://github.com/pypa/advisory-database/blob/main/vulns/python-sql/PYSEC-2026-1855.yaml"}}],"schema_version":"1.7.5","severity":[{"type":"CVSS_V3","score":"CVSS:3.0/AV:N/AC:L/PR:H/UI:N/S:U/C:H/I:H/A:N"}]}