@hypequery/clickhouse has SQL Injection in parameter escaping that allows arbitrary SQL execution
28Vexday Risk Score
No sign of exploitation. No public exploitation artifact known so far.
ssvc Trackcvss 9.8epss 0.4%
exploitation probability
0.4%top 64% of all CVEs
observed exploitation
nono source reports it
Hypequery is a TypeScript semantic layer for ClickHouse. Prior to 2.5.1, escapeValue() in packages/clickhouse/src/core/utils.ts did not escape backslashes before single quotes during parameter substitution, allowing attacker controlled query parameters with a trailing backslash to escape the closing quote and inject arbitrary SQL. This issue is fixed in version 2.0.2. Version 2.0.2 fixes string parameters, while version 2.5.1 fixes all known vectors. Upgrading to 2.5.1 or later is the only complete fix. In versions 2.0.2 through 2.5.0, serializing non-scalar parameters with JSON.stringify() before passing them is a workaround for the object/array vector only.
CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:H/I:H/A:H
Affected products
hypequery · hypequeryReferences
https://github.com/hypequery/hypequery/blob/main/packages/clickhouse/CHANGELOG.md#202https://github.com/hypequery/hypequery/commit/2879161a810fed2c2222f785816ff05510976960https://github.com/hypequery/hypequery/commit/2dc1df7baehttps://github.com/hypequery/hypequery/commit/4dfa9d77d70a08b970e722268b75ca7d13db0bdfhttps://github.com/hypequery/hypequery/pull/349https://github.com/hypequery/hypequery/releases/tag/@hypequery/clickhouse@2.0.2https://github.com/hypequery/hypequery/releases/tag/@hypequery/clickhouse@2.5.1https://github.com/hypequery/hypequery/security/advisories/GHSA-6wcc-39rp-hh9p