HoneySQL unchecked entity names can lead to SQL injection results

Summary

HoneySQL turns Clojure data structures into SQL. From 2.0.0 until 2.7.1392, applications that pass user input or other arbitrary data into the HoneySQL `DSL` by calling `keyword` or `symbol` on that input can produce SQL strings that facilitate SQL injection when executed unchanged by a `JDBC` driver. Some formatters do not apply the existing suspicious-character check to the resulting entity names. The impact depends on the privileges of the database connection executing the generated statement. Input validation before constructing `keyword` or `symbol` entities is a workaround. The maintainer-designated fixed version is 2.7.1392.

Remediation

1. Inventory every seancorfield honeysql deployment, including staging.
2. No fixed version appears in the public sources yet. Check the references below and the vendor directly.

References

• Referencehttps://github.com/seancorfield/honeysql/commit/1141fcd4597393d2af61c20a7cc82b8f1b3cea4a
• Referencehttps://github.com/seancorfield/honeysql/compare/v2.7.1390...v2.7.1392
• Referencehttps://github.com/seancorfield/honeysql/releases/tag/v2.7.1392
• Referencehttps://github.com/seancorfield/honeysql/security/advisories/GHSA-fcfq-xqgp-8v97