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 |
<CodeSystem xmlns="http://hl7.org/fhir">
<id value="SQLContentTypeCodes"/>
<text>
<status value="generated"/>
<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>
</text>
<url value="https://sql-on-fhir.org/ig/CodeSystem/SQLContentTypeCodes"/>
<version value="2.1.0-pre"/>
<name value="SQLContentTypeCodes"/>
<title value="SQL Content Type Codes"/>
<status value="draft"/>
<date value="2026-02-24T21:00:17+00:00"/>
<publisher value="SQL on FHIR Working Group"/>
<contact>
<name value="SQL on FHIR Working Group"/>
<telecom>
<system value="url"/>
<value value="https://sql-on-fhir.org"/>
</telecom>
</contact>
<description
value="Permitted contentType values for SQLQuery attachments, including dialect-specific variants."/>
<jurisdiction>
<coding>
<system value="http://unstats.un.org/unsd/methods/m49/m49.htm"/>
<code value="001"/>
<display value="World"/>
</coding>
</jurisdiction>
<content value="complete"/>
<count value="23"/>
<concept>
<code value="application/sql"/>
<display value="SQL"/>
<definition value="Standard SQL content (no dialect specified)"/>
</concept>
<concept>
<code value="application/sql;dialect=ansi-sql"/>
<display value="ANSI SQL"/>
<definition value="SQL content using ANSI SQL dialect"/>
</concept>
<concept>
<code value="application/sql;dialect=bigquery"/>
<display value="BigQuery"/>
<definition value="SQL content using Google BigQuery dialect"/>
</concept>
<concept>
<code value="application/sql;dialect=clickhouse"/>
<display value="ClickHouse"/>
<definition value="SQL content using ClickHouse dialect"/>
</concept>
<concept>
<code value="application/sql;dialect=db2"/>
<display value="IBM DB2"/>
<definition value="SQL content using IBM DB2 dialect"/>
</concept>
<concept>
<code value="application/sql;dialect=duckdb"/>
<display value="DuckDB"/>
<definition value="SQL content using DuckDB dialect"/>
</concept>
<concept>
<code value="application/sql;dialect=h2"/>
<display value="H2"/>
<definition value="SQL content using H2 dialect"/>
</concept>
<concept>
<code value="application/sql;dialect=hive"/>
<display value="Hive"/>
<definition value="SQL content using Apache Hive dialect"/>
</concept>
<concept>
<code value="application/sql;dialect=hsqldb"/>
<display value="HSQLDB"/>
<definition value="SQL content using HyperSQL dialect"/>
</concept>
<concept>
<code value="application/sql;dialect=mariadb"/>
<display value="MariaDB"/>
<definition value="SQL content using MariaDB dialect"/>
</concept>
<concept>
<code value="application/sql;dialect=mysql"/>
<display value="MySQL"/>
<definition value="SQL content using MySQL dialect"/>
</concept>
<concept>
<code value="application/sql;dialect=oracle"/>
<display value="Oracle SQL"/>
<definition value="SQL content using Oracle dialect"/>
</concept>
<concept>
<code value="application/sql;dialect=postgresql"/>
<display value="PostgreSQL"/>
<definition value="SQL content using PostgreSQL dialect"/>
</concept>
<concept>
<code value="application/sql;dialect=presto"/>
<display value="Presto"/>
<definition value="SQL content using Presto dialect"/>
</concept>
<concept>
<code value="application/sql;dialect=redshift"/>
<display value="Amazon Redshift"/>
<definition value="SQL content using Amazon Redshift dialect"/>
</concept>
<concept>
<code value="application/sql;dialect=snowflake"/>
<display value="Snowflake"/>
<definition value="SQL content using Snowflake dialect"/>
</concept>
<concept>
<code value="application/sql;dialect=spark-sql"/>
<display value="Spark SQL"/>
<definition value="SQL content using Apache Spark SQL dialect"/>
</concept>
<concept>
<code value="application/sql;dialect=sql-2"/>
<display value="SQL-2"/>
<definition value="SQL content using SQL-2 dialect"/>
</concept>
<concept>
<code value="application/sql;dialect=sql-server"/>
<display value="SQL Server"/>
<definition value="SQL content using Microsoft SQL Server dialect"/>
</concept>
<concept>
<code value="application/sql;dialect=sqlite"/>
<display value="SQLite"/>
<definition value="SQL content using SQLite dialect"/>
</concept>
<concept>
<code value="application/sql;dialect=teradata"/>
<display value="Teradata"/>
<definition value="SQL content using Teradata dialect"/>
</concept>
<concept>
<code value="application/sql;dialect=trino"/>
<display value="Trino"/>
<definition value="SQL content using Trino dialect"/>
</concept>
<concept>
<code value="application/sql;dialect=vertica"/>
<display value="Vertica"/>
<definition value="SQL content using Vertica dialect"/>
</concept>
</CodeSystem>