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.
https://github.com/hypequery/hypequery/security/advisories/GHSA-6wcc-39rp-hh9p
https://github.com/hypequery/hypequery/releases/tag/@hypequery/[email protected]
https://github.com/hypequery/hypequery/releases/tag/@hypequery/[email protected]
https://github.com/hypequery/hypequery/pull/349
https://github.com/hypequery/hypequery/commit/4dfa9d77d70a08b970e722268b75ca7d13db0bdf
https://github.com/hypequery/hypequery/commit/2dc1df7bae
https://github.com/hypequery/hypequery/commit/2879161a810fed2c2222f785816ff05510976960
https://github.com/hypequery/hypequery/blob/main/packages/clickhouse/CHANGELOG.md#202