CVE-2026-87016: Sqlalchemy Json Contains Wildcard Matching
Using `.contains()` with a dictionary or list on a SQLAlchemy JSON column compiles to a `LIKE '%...%'` substring match on SQLite and MySQL. This allows SQL wildcards (`%`, `_`) in user inputs to match unintended records, potentially leading to identity spoofing or authentication bypass. Use JSON subscripting with exact comparison (e.g., `Column[key].as_strin
Pythongreprules fetch cve-2026-87016-sqlalchemy-json-contains-wildcard-matching --engine opengrepDescription
Using `.contains()` with a dictionary or list on a SQLAlchemy JSON column compiles to a `LIKE '%...%'` substring match on SQLite and MySQL. This allows SQL wildcards (`%`, `_`) in user inputs to match unintended records, potentially leading to identity spoofing or authentication bypass. Use JSON subscripting with exact comparison (e.g., `Column[key].as_strin
Community feedback
0 rule-level signals from signed-in users.
- Useful reports
- 0
- Context false positives
- 0
- Metadata suggestions
- 0
Contextual precision
Aggregated from approved scan feedback. False-positive reports describe observed scan contexts, not a global rule verdict.
- Findings observed
- 0
- Projects
- 0
- Reporters
- 0
Precision details are collecting more signed-in reports before verdict counts or ratios are emphasized.
No approved finding verdicts yet.
No scan diagnostics reported yet.