SQL on FHIR
2.1.0-pre - release
SQL on FHIR
2.1.0-pre - release
SQL on FHIR, published by SQL on FHIR Working Group. This guide is not an authorized publication; it is the continuous build for version 2.1.0-pre built by the FHIR (HL7® FHIR® Standard) CI Build. This version is based on the current content of https://github.com/FHIR/sql-on-fhir-v2/ and changes regularly. See the Directory of published versions
| Draft as of 2026-02-24 |
{
"resourceType" : "CodeSystem",
"id" : "SQLContentTypeCodes",
"text" : {
"status" : "generated",
"div" : "<div xmlns=\"http://www.w3.org/1999/xhtml\"><p class=\"res-header-id\"><b>Generated Narrative: CodeSystem SQLContentTypeCodes</b></p><a name=\"SQLContentTypeCodes\"> </a><a name=\"hcSQLContentTypeCodes\"> </a><p>This code system <code>https://sql-on-fhir.org/ig/CodeSystem/SQLContentTypeCodes</code> defines the following codes:</p><table class=\"codes\"><tr><td style=\"white-space:nowrap\"><b>Code</b></td><td><b>Display</b></td><td><b>Definition</b></td></tr><tr><td style=\"white-space:nowrap\">application/sql<a name=\"SQLContentTypeCodes-application.47sql\"> </a></td><td>SQL</td><td>Standard SQL content (no dialect specified)</td></tr><tr><td style=\"white-space:nowrap\">application/sql;dialect=ansi-sql<a name=\"SQLContentTypeCodes-application.47sql.59dialect.61ansi-sql\"> </a></td><td>ANSI SQL</td><td>SQL content using ANSI SQL dialect</td></tr><tr><td style=\"white-space:nowrap\">application/sql;dialect=bigquery<a name=\"SQLContentTypeCodes-application.47sql.59dialect.61bigquery\"> </a></td><td>BigQuery</td><td>SQL content using Google BigQuery dialect</td></tr><tr><td style=\"white-space:nowrap\">application/sql;dialect=clickhouse<a name=\"SQLContentTypeCodes-application.47sql.59dialect.61clickhouse\"> </a></td><td>ClickHouse</td><td>SQL content using ClickHouse dialect</td></tr><tr><td style=\"white-space:nowrap\">application/sql;dialect=db2<a name=\"SQLContentTypeCodes-application.47sql.59dialect.61db2\"> </a></td><td>IBM DB2</td><td>SQL content using IBM DB2 dialect</td></tr><tr><td style=\"white-space:nowrap\">application/sql;dialect=duckdb<a name=\"SQLContentTypeCodes-application.47sql.59dialect.61duckdb\"> </a></td><td>DuckDB</td><td>SQL content using DuckDB dialect</td></tr><tr><td style=\"white-space:nowrap\">application/sql;dialect=h2<a name=\"SQLContentTypeCodes-application.47sql.59dialect.61h2\"> </a></td><td>H2</td><td>SQL content using H2 dialect</td></tr><tr><td style=\"white-space:nowrap\">application/sql;dialect=hive<a name=\"SQLContentTypeCodes-application.47sql.59dialect.61hive\"> </a></td><td>Hive</td><td>SQL content using Apache Hive dialect</td></tr><tr><td style=\"white-space:nowrap\">application/sql;dialect=hsqldb<a name=\"SQLContentTypeCodes-application.47sql.59dialect.61hsqldb\"> </a></td><td>HSQLDB</td><td>SQL content using HyperSQL dialect</td></tr><tr><td style=\"white-space:nowrap\">application/sql;dialect=mariadb<a name=\"SQLContentTypeCodes-application.47sql.59dialect.61mariadb\"> </a></td><td>MariaDB</td><td>SQL content using MariaDB dialect</td></tr><tr><td style=\"white-space:nowrap\">application/sql;dialect=mysql<a name=\"SQLContentTypeCodes-application.47sql.59dialect.61mysql\"> </a></td><td>MySQL</td><td>SQL content using MySQL dialect</td></tr><tr><td style=\"white-space:nowrap\">application/sql;dialect=oracle<a name=\"SQLContentTypeCodes-application.47sql.59dialect.61oracle\"> </a></td><td>Oracle SQL</td><td>SQL content using Oracle dialect</td></tr><tr><td style=\"white-space:nowrap\">application/sql;dialect=postgresql<a name=\"SQLContentTypeCodes-application.47sql.59dialect.61postgresql\"> </a></td><td>PostgreSQL</td><td>SQL content using PostgreSQL dialect</td></tr><tr><td style=\"white-space:nowrap\">application/sql;dialect=presto<a name=\"SQLContentTypeCodes-application.47sql.59dialect.61presto\"> </a></td><td>Presto</td><td>SQL content using Presto dialect</td></tr><tr><td style=\"white-space:nowrap\">application/sql;dialect=redshift<a name=\"SQLContentTypeCodes-application.47sql.59dialect.61redshift\"> </a></td><td>Amazon Redshift</td><td>SQL content using Amazon Redshift dialect</td></tr><tr><td style=\"white-space:nowrap\">application/sql;dialect=snowflake<a name=\"SQLContentTypeCodes-application.47sql.59dialect.61snowflake\"> </a></td><td>Snowflake</td><td>SQL content using Snowflake dialect</td></tr><tr><td style=\"white-space:nowrap\">application/sql;dialect=spark-sql<a name=\"SQLContentTypeCodes-application.47sql.59dialect.61spark-sql\"> </a></td><td>Spark SQL</td><td>SQL content using Apache Spark SQL dialect</td></tr><tr><td style=\"white-space:nowrap\">application/sql;dialect=sql-2<a name=\"SQLContentTypeCodes-application.47sql.59dialect.61sql-2\"> </a></td><td>SQL-2</td><td>SQL content using SQL-2 dialect</td></tr><tr><td style=\"white-space:nowrap\">application/sql;dialect=sql-server<a name=\"SQLContentTypeCodes-application.47sql.59dialect.61sql-server\"> </a></td><td>SQL Server</td><td>SQL content using Microsoft SQL Server dialect</td></tr><tr><td style=\"white-space:nowrap\">application/sql;dialect=sqlite<a name=\"SQLContentTypeCodes-application.47sql.59dialect.61sqlite\"> </a></td><td>SQLite</td><td>SQL content using SQLite dialect</td></tr><tr><td style=\"white-space:nowrap\">application/sql;dialect=teradata<a name=\"SQLContentTypeCodes-application.47sql.59dialect.61teradata\"> </a></td><td>Teradata</td><td>SQL content using Teradata dialect</td></tr><tr><td style=\"white-space:nowrap\">application/sql;dialect=trino<a name=\"SQLContentTypeCodes-application.47sql.59dialect.61trino\"> </a></td><td>Trino</td><td>SQL content using Trino dialect</td></tr><tr><td style=\"white-space:nowrap\">application/sql;dialect=vertica<a name=\"SQLContentTypeCodes-application.47sql.59dialect.61vertica\"> </a></td><td>Vertica</td><td>SQL content using Vertica dialect</td></tr></table></div>"
},
"url" : "https://sql-on-fhir.org/ig/CodeSystem/SQLContentTypeCodes",
"version" : "2.1.0-pre",
"name" : "SQLContentTypeCodes",
"title" : "SQL Content Type Codes",
"status" : "draft",
"date" : "2026-02-24T21:00:17+00:00",
"publisher" : "SQL on FHIR Working Group",
"contact" : [
{
"name" : "SQL on FHIR Working Group",
"telecom" : [
{
"system" : "url",
"value" : "https://sql-on-fhir.org"
}
]
}
],
"description" : "Permitted contentType values for SQLQuery attachments, including dialect-specific variants.",
"jurisdiction" : [
{
"coding" : [
{
"system" : "http://unstats.un.org/unsd/methods/m49/m49.htm",
"code" : "001",
"display" : "World"
}
]
}
],
"content" : "complete",
"count" : 23,
"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"
}
]
}