{
  "code": null,
  "collection": "architecture",
  "href": "https://banes-lab.com/ontology#architecture-parameterized-queries",
  "id": "parameterized-queries",
  "kind": "mechanism",
  "layer": {
    "href": "https://banes-lab.com/ontology/schema#layer-security-core",
    "json": "https://banes-lab.com/json/records/layer/security-core",
    "label": "Security Core",
    "markdown": "https://banes-lab.com/records/layer/security-core.md",
    "ref": "layer:security-core"
  },
  "name": "Parameterized Queries",
  "ref": "architecture:parameterized-queries",
  "relations": [
    {
      "links": [
        {
          "href": "https://banes-lab.com/ontology/lexicon#lexicon-query-parameter-binding",
          "json": "https://banes-lab.com/json/records/lexicon/query-parameter-binding",
          "label": "Query Parameter Binding",
          "markdown": "https://banes-lab.com/records/lexicon/query-parameter-binding.md",
          "ref": "lexicon:query-parameter-binding"
        }
      ],
      "relation": "requires"
    },
    {
      "links": [
        {
          "href": "https://banes-lab.com/ontology#architecture-input-validation",
          "json": "https://banes-lab.com/json/records/architecture/input-validation",
          "label": "Input Validation",
          "markdown": "https://banes-lab.com/records/architecture/input-validation.md",
          "ref": "architecture:input-validation"
        },
        {
          "href": "https://banes-lab.com/ontology#architecture-secure-by-default",
          "json": "https://banes-lab.com/json/records/architecture/secure-by-default",
          "label": "Secure by Default",
          "markdown": "https://banes-lab.com/records/architecture/secure-by-default.md",
          "ref": "architecture:secure-by-default"
        }
      ],
      "relation": "reinforces"
    },
    {
      "links": [
        {
          "href": "https://banes-lab.com/ontology/lexicon#lexicon-injection-safe-data-access",
          "json": "https://banes-lab.com/json/records/lexicon/injection-safe-data-access",
          "label": "Injection-Safe Data Access",
          "markdown": "https://banes-lab.com/records/lexicon/injection-safe-data-access.md",
          "ref": "lexicon:injection-safe-data-access"
        }
      ],
      "relation": "enables"
    },
    {
      "links": [
        {
          "href": "https://banes-lab.com/ontology/lexicon#lexicon-string-concatenated-sql",
          "json": "https://banes-lab.com/json/records/lexicon/string-concatenated-sql",
          "label": "String-Concatenated SQL",
          "markdown": "https://banes-lab.com/records/lexicon/string-concatenated-sql.md",
          "ref": "lexicon:string-concatenated-sql"
        }
      ],
      "relation": "conflicts-with"
    },
    {
      "links": [
        {
          "href": "https://banes-lab.com/ontology/lexicon#lexicon-dynamic-query-flexibility",
          "json": "https://banes-lab.com/json/records/lexicon/dynamic-query-flexibility",
          "label": "Dynamic Query Flexibility",
          "markdown": "https://banes-lab.com/records/lexicon/dynamic-query-flexibility.md",
          "ref": "lexicon:dynamic-query-flexibility"
        }
      ],
      "relation": "tensions-with"
    },
    {
      "links": [
        {
          "href": "https://banes-lab.com/ontology/schema#tension-dynamic-query-flexibility-parameterized-queries",
          "json": "https://banes-lab.com/json/records/tension/dynamic-query-flexibility-parameterized-queries",
          "label": "Parameterized Queries / Dynamic Query Flexibility",
          "markdown": "https://banes-lab.com/records/tension/dynamic-query-flexibility-parameterized-queries.md",
          "ref": "tension:dynamic-query-flexibility-parameterized-queries"
        }
      ],
      "relation": "tensions"
    },
    {
      "links": [
        {
          "href": "https://banes-lab.com/ontology/lexicon#lexicon-string-concatenated-sql",
          "json": "https://banes-lab.com/json/records/lexicon/string-concatenated-sql",
          "label": "String-Concatenated SQL",
          "markdown": "https://banes-lab.com/records/lexicon/string-concatenated-sql.md",
          "ref": "lexicon:string-concatenated-sql"
        }
      ],
      "relation": "violated-by"
    },
    {
      "links": [
        {
          "href": "https://banes-lab.com/ontology/schema#vocabulary-severity-mandatory",
          "json": "https://banes-lab.com/json/records/vocabulary/severity-mandatory",
          "label": "mandatory",
          "markdown": "https://banes-lab.com/records/vocabulary/severity-mandatory.md",
          "ref": "vocabulary:severity-mandatory"
        }
      ],
      "relation": "severity"
    },
    {
      "links": [
        {
          "href": "https://banes-lab.com/ontology#architecture-category-security-privacy-compliance-governance",
          "json": "https://banes-lab.com/json/records/architecture-category/security-privacy-compliance-governance",
          "label": "Security / Privacy / Compliance / Governance",
          "markdown": "https://banes-lab.com/records/architecture-category/security-privacy-compliance-governance.md",
          "ref": "architecture-category:security-privacy-compliance-governance"
        }
      ],
      "relation": "category"
    },
    {
      "links": [
        {
          "href": "https://banes-lab.com/ontology#architecture-category-security-privacy-compliance-governance",
          "json": "https://banes-lab.com/json/ontology/principles/architecture-category-security-privacy-compliance-governance",
          "label": "Security / Privacy / Compliance / Governance",
          "markdown": "https://banes-lab.com/ontology/principles/architecture-category-security-privacy-compliance-governance.md",
          "ref": "chapter:/ontology#architecture-category-security-privacy-compliance-governance"
        },
        {
          "href": "https://banes-lab.com/ontology/lexicon#lexicon-category-security-privacy-compliance",
          "json": "https://banes-lab.com/json/ontology/lexicon/lexicon-category-security-privacy-compliance",
          "label": "Security Privacy Compliance",
          "markdown": "https://banes-lab.com/ontology/lexicon/lexicon-category-security-privacy-compliance.md",
          "ref": "chapter:/ontology/lexicon#lexicon-category-security-privacy-compliance"
        },
        {
          "href": "https://banes-lab.com/ontology/schema#the-vocabulary-severity",
          "json": "https://banes-lab.com/json/ontology/schema/the-vocabulary-severity",
          "label": "Severity levels",
          "markdown": "https://banes-lab.com/ontology/schema/the-vocabulary-severity.md",
          "ref": "chapter:/ontology/schema#the-vocabulary-severity"
        },
        {
          "href": "https://banes-lab.com/ontology/schema#the-resolutions",
          "json": "https://banes-lab.com/json/ontology/schema/the-resolutions",
          "label": "The resolutions",
          "markdown": "https://banes-lab.com/ontology/schema/the-resolutions.md",
          "ref": "chapter:/ontology/schema#the-resolutions"
        }
      ],
      "relation": "linked-from"
    }
  ],
  "summary": "A mechanism that sends query text and values to the database separately, so values are never parsed as query syntax.",
  "siblings": {
    "next": {
      "href": "https://banes-lab.com/ontology#architecture-session-management",
      "json": "https://banes-lab.com/json/records/architecture/session-management",
      "label": "Session Management",
      "markdown": "https://banes-lab.com/records/architecture/session-management.md",
      "ref": "architecture:session-management"
    },
    "previous": {
      "href": "https://banes-lab.com/ontology#architecture-csrf-protection",
      "json": "https://banes-lab.com/json/records/architecture/csrf-protection",
      "label": "CSRF Protection",
      "markdown": "https://banes-lab.com/records/architecture/csrf-protection.md",
      "ref": "architecture:csrf-protection"
    }
  },
  "up": {
    "href": null,
    "json": "https://banes-lab.com/json/api/records/architecture",
    "label": "Architecture principles",
    "markdown": "https://banes-lab.com/api/records/architecture.md",
    "ref": "api:records/architecture"
  },
  "aliases": [],
  "exemplar": {
    "after": "db.query(\"select * from foos where id = $1\", [id]);",
    "before": "db.query(`select * from foos where id = '${id}'`);",
    "lang": "ts",
    "medium": "code"
  },
  "formedBy": null,
  "scope": [
    "service",
    "database",
    "security"
  ],
  "severity": "mandatory"
}