{
  "description": "Permitted contentType values for SQLQuery attachments, including dialect-specific variants.",
  "_filename": "CodeSystem-SQLContentTypeCodes.json",
  "package_name": "hl7.fhir.uv.sql-on-fhir",
  "date": "2026-08-14T02:49:31+10:00",
  "publisher": "HL7 International / FHIR Infrastructure",
  "jurisdiction": [ {
    "coding": [ {
      "code": "001",
      "system": "http://unstats.un.org/unsd/methods/m49/m49.htm",
      "display": "World"
    } ]
  } ],
  "content": "complete",
  "name": "SQLContentTypeCodes",
  "type": null,
  "experimental": "false",
  "resourceType": "CodeSystem",
  "title": "SQL Content Type Codes",
  "package_version": "3.0.0-ballot",
  "extension": [ {
    "url": "http://hl7.org/fhir/StructureDefinition/structuredefinition-wg",
    "valueCode": "fhir"
  }, {
    "url": "http://hl7.org/fhir/StructureDefinition/structuredefinition-fmm",
    "valueInteger": 2,
    "_valueInteger": {
      "extension": [ {
        "url": "http://hl7.org/fhir/StructureDefinition/structuredefinition-conformance-derivedFrom",
        "valueCanonical": "http://hl7.org/fhir/uv/sql-on-fhir/ImplementationGuide/hl7.fhir.uv.sql-on-fhir"
      } ]
    }
  }, {
    "url": "http://hl7.org/fhir/StructureDefinition/structuredefinition-standards-status",
    "valueCode": "trial-use",
    "_valueCode": {
      "extension": [ {
        "url": "http://hl7.org/fhir/StructureDefinition/structuredefinition-conformance-derivedFrom",
        "valueCanonical": "http://hl7.org/fhir/uv/sql-on-fhir/ImplementationGuide/hl7.fhir.uv.sql-on-fhir"
      } ]
    }
  } ],
  "status": "active",
  "id": "a0734edb-ebbe-4874-9422-21bf5884184f",
  "kind": null,
  "count": 23,
  "url": "http://hl7.org/fhir/uv/sql-on-fhir/CodeSystem/SQLContentTypeCodes",
  "identifier": [ {
    "value": "urn:oid:2.16.840.1.113883.4.642.40.77.16.4",
    "system": "urn:ietf:rfc:3986"
  } ],
  "concept": [ {
    "code": "application/sql",
    "display": "SQL",
    "definition": "Standard SQL content (no dialect specified)"
  }, {
    "code": "application/sql;dialect=ansi-sql",
    "display": "ANSI SQL",
    "definition": "SQL content using ANSI SQL dialect"
  }, {
    "code": "application/sql;dialect=bigquery",
    "display": "BigQuery",
    "definition": "SQL content using Google BigQuery dialect"
  }, {
    "code": "application/sql;dialect=clickhouse",
    "display": "ClickHouse",
    "definition": "SQL content using ClickHouse dialect"
  }, {
    "code": "application/sql;dialect=db2",
    "display": "IBM DB2",
    "definition": "SQL content using IBM DB2 dialect"
  }, {
    "code": "application/sql;dialect=duckdb",
    "display": "DuckDB",
    "definition": "SQL content using DuckDB dialect"
  }, {
    "code": "application/sql;dialect=h2",
    "display": "H2",
    "definition": "SQL content using H2 dialect"
  }, {
    "code": "application/sql;dialect=hive",
    "display": "Hive",
    "definition": "SQL content using Apache Hive dialect"
  }, {
    "code": "application/sql;dialect=hsqldb",
    "display": "HSQLDB",
    "definition": "SQL content using HyperSQL dialect"
  }, {
    "code": "application/sql;dialect=mariadb",
    "display": "MariaDB",
    "definition": "SQL content using MariaDB dialect"
  }, {
    "code": "application/sql;dialect=mysql",
    "display": "MySQL",
    "definition": "SQL content using MySQL dialect"
  }, {
    "code": "application/sql;dialect=oracle",
    "display": "Oracle SQL",
    "definition": "SQL content using Oracle dialect"
  }, {
    "code": "application/sql;dialect=postgresql",
    "display": "PostgreSQL",
    "definition": "SQL content using PostgreSQL dialect"
  }, {
    "code": "application/sql;dialect=presto",
    "display": "Presto",
    "definition": "SQL content using Presto dialect"
  }, {
    "code": "application/sql;dialect=redshift",
    "display": "Amazon Redshift",
    "definition": "SQL content using Amazon Redshift dialect"
  }, {
    "code": "application/sql;dialect=snowflake",
    "display": "Snowflake",
    "definition": "SQL content using Snowflake dialect"
  }, {
    "code": "application/sql;dialect=spark-sql",
    "display": "Spark SQL",
    "definition": "SQL content using Apache Spark SQL dialect"
  }, {
    "code": "application/sql;dialect=sql-2",
    "display": "SQL-2",
    "definition": "SQL content using SQL-2 dialect"
  }, {
    "code": "application/sql;dialect=sql-server",
    "display": "SQL Server",
    "definition": "SQL content using Microsoft SQL Server dialect"
  }, {
    "code": "application/sql;dialect=sqlite",
    "display": "SQLite",
    "definition": "SQL content using SQLite dialect"
  }, {
    "code": "application/sql;dialect=teradata",
    "display": "Teradata",
    "definition": "SQL content using Teradata dialect"
  }, {
    "code": "application/sql;dialect=trino",
    "display": "Trino",
    "definition": "SQL content using Trino dialect"
  }, {
    "code": "application/sql;dialect=vertica",
    "display": "Vertica",
    "definition": "SQL content using Vertica dialect"
  } ],
  "caseSensitive": true,
  "version": "3.0.0-ballot",
  "contact": [ {
    "name": "HL7 International / FHIR Infrastructure",
    "telecom": [ {
      "value": "http://www.hl7.org/Special/committees/fiwg",
      "system": "url"
    } ]
  } ]
}