{
  "schema_version": "1.4.0",
  "id": "GHSA-4qhx-g9wp-g9m6",
  "modified": "2021-09-16T21:00:23Z",
  "published": "2019-06-14T16:09:01Z",
  "aliases": [],
  "summary": "Failure to sanitize quotes which can lead to sql injection in squel",
  "details": "All versions of `squel` are vulnerable to sql injection.\n\nThe `squel` package does not properly escape user provided input when provided using the `setFields` method. This could lead to sql injection if the query was then executed.\n\nProof of concept demonstrating the injection of a single quote into a generated sql statement from user provided input.\n```\n> console.log(squel.insert().into('buh').setFields({foo: \"bar'baz\"}).toString());\nINSERT INTO buh (foo) VALUES ('bar'baz')\n```\n\n\n## Recommendation\n\nThere is no fix at this time and the issue has been reported publicly. Consider using another query builder that provides strong guarantees for input sanitization to prevent sql injection attacks.",
  "severity": [],
  "affected": [
    {
      "package": {
        "ecosystem": "npm",
        "name": "squel"
      },
      "ranges": [
        {
          "type": "ECOSYSTEM",
          "events": [
            {
              "introduced": "0"
            },
            {
              "last_affected": "5.13.0"
            }
          ]
        }
      ]
    }
  ],
  "references": [
    {
      "type": "WEB",
      "url": "https://github.com/hiddentao/squel/issues/350"
    },
    {
      "type": "PACKAGE",
      "url": "https://github.com/hiddentao/squel"
    },
    {
      "type": "WEB",
      "url": "https://www.npmjs.com/advisories/575"
    }
  ],
  "database_specific": {
    "cwe_ids": [
      "CWE-74",
      "CWE-89"
    ],
    "severity": "CRITICAL",
    "github_reviewed": true,
    "github_reviewed_at": "2019-06-14T16:08:38Z",
    "nvd_published_at": null
  }
}