SQL on FHIR
2.1.0-pre - release International flag

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

CodeSystem: SQL Content Type Codes

Official URL: https://sql-on-fhir.org/ig/CodeSystem/SQLContentTypeCodes Version: 2.1.0-pre
Draft as of 2026-02-24 Computable Name: SQLContentTypeCodes

Permitted contentType values for SQLQuery attachments, including dialect-specific variants.

This Code system is referenced in the content logical definition of the following value sets:

This code system https://sql-on-fhir.org/ig/CodeSystem/SQLContentTypeCodes defines the following codes:

CodeDisplayDefinition
application/sql SQL Standard SQL content (no dialect specified)
application/sql;dialect=ansi-sql ANSI SQL SQL content using ANSI SQL dialect
application/sql;dialect=bigquery BigQuery SQL content using Google BigQuery dialect
application/sql;dialect=clickhouse ClickHouse SQL content using ClickHouse dialect
application/sql;dialect=db2 IBM DB2 SQL content using IBM DB2 dialect
application/sql;dialect=duckdb DuckDB SQL content using DuckDB dialect
application/sql;dialect=h2 H2 SQL content using H2 dialect
application/sql;dialect=hive Hive SQL content using Apache Hive dialect
application/sql;dialect=hsqldb HSQLDB SQL content using HyperSQL dialect
application/sql;dialect=mariadb MariaDB SQL content using MariaDB dialect
application/sql;dialect=mysql MySQL SQL content using MySQL dialect
application/sql;dialect=oracle Oracle SQL SQL content using Oracle dialect
application/sql;dialect=postgresql PostgreSQL SQL content using PostgreSQL dialect
application/sql;dialect=presto Presto SQL content using Presto dialect
application/sql;dialect=redshift Amazon Redshift SQL content using Amazon Redshift dialect
application/sql;dialect=snowflake Snowflake SQL content using Snowflake dialect
application/sql;dialect=spark-sql Spark SQL SQL content using Apache Spark SQL dialect
application/sql;dialect=sql-2 SQL-2 SQL content using SQL-2 dialect
application/sql;dialect=sql-server SQL Server SQL content using Microsoft SQL Server dialect
application/sql;dialect=sqlite SQLite SQL content using SQLite dialect
application/sql;dialect=teradata Teradata SQL content using Teradata dialect
application/sql;dialect=trino Trino SQL content using Trino dialect
application/sql;dialect=vertica Vertica SQL content using Vertica dialect