PyPI: sqlo

SFTY-20251201-59224

Safety legacy ID: pyup.io-82091

Affected versions of this package are vulnerable to SQL Injection, leading to Mass Data Modification. Multiple query builder functions fail to validate table and column identifiers, enforce type constraints on raw expressions, handle empty IN clauses safely, and require WHERE clauses for destructive operations. This leads to arbitrary SQL execution and unintended data modification.

Created at: Dec 1, 2025Updated at: Dec 1, 2025

Overview

Affected versions of this package are vulnerable to SQL Injection, leading to Mass Data Modification. Multiple query builder functions fail to validate table and column identifiers, enforce type constraints on raw expressions, handle empty IN clauses safely, and require WHERE clauses for destructive operations. This leads to arbitrary SQL execution and unintended data modification.

Advisory

Affected versions of this package are vulnerable to SQL Injection, leading to Mass Data Modification. Multiple query builder functions fail to validate table and column identifiers, enforce type constraints on raw expressions, handle empty IN clauses safely, and require WHERE clauses for destructive operations. This leads to arbitrary SQL execution and unintended data modification.

Affected Package

Affecting sqlo package, versions<0.1.0

Also affects

---

How to Fix

Upgradesqloto0.1.0or higher.

Mitigation and Workarounds

---

Vulnerable Functions

Functions linked to known vulnerabilities.

Vulnerable function data is available for Enterprise customers

Book a call with us to see Safety in action.

Safety

Verified by Safety

Our Cybersecurity Intelligence Team reviewed this vulnerability. We combine public data with our own research to find issues not yet reported to public sources.

Learn more