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
| Official URL: https://sql-on-fhir.org/ig/ValueSet/AllSQLContentTypeCodes | Version: 2.1.0-pre | |||
| Draft as of 2026-02-24 | Computable Name: AllSQLContentTypeCodes | |||
ValueSet of all codes from SQL Content Type Codes codesystem
References
https://sql-on-fhir.org/ig/CodeSystem/SQLContentTypeCodes version 📦2.1.0-pre
Expansion performed internally based on codesystem SQL Content Type Codes v2.1.0-pre (CodeSystem)
This value set contains 23 concepts
| System | Code | Display (en) | Definition | JSON | XML |
https://sql-on-fhir.org/ig/CodeSystem/SQLContentTypeCodes | application/sql | SQL | Standard SQL content (no dialect specified) | ||
https://sql-on-fhir.org/ig/CodeSystem/SQLContentTypeCodes | application/sql;dialect=ansi-sql | ANSI SQL | SQL content using ANSI SQL dialect | ||
https://sql-on-fhir.org/ig/CodeSystem/SQLContentTypeCodes | application/sql;dialect=bigquery | BigQuery | SQL content using Google BigQuery dialect | ||
https://sql-on-fhir.org/ig/CodeSystem/SQLContentTypeCodes | application/sql;dialect=clickhouse | ClickHouse | SQL content using ClickHouse dialect | ||
https://sql-on-fhir.org/ig/CodeSystem/SQLContentTypeCodes | application/sql;dialect=db2 | IBM DB2 | SQL content using IBM DB2 dialect | ||
https://sql-on-fhir.org/ig/CodeSystem/SQLContentTypeCodes | application/sql;dialect=duckdb | DuckDB | SQL content using DuckDB dialect | ||
https://sql-on-fhir.org/ig/CodeSystem/SQLContentTypeCodes | application/sql;dialect=h2 | H2 | SQL content using H2 dialect | ||
https://sql-on-fhir.org/ig/CodeSystem/SQLContentTypeCodes | application/sql;dialect=hive | Hive | SQL content using Apache Hive dialect | ||
https://sql-on-fhir.org/ig/CodeSystem/SQLContentTypeCodes | application/sql;dialect=hsqldb | HSQLDB | SQL content using HyperSQL dialect | ||
https://sql-on-fhir.org/ig/CodeSystem/SQLContentTypeCodes | application/sql;dialect=mariadb | MariaDB | SQL content using MariaDB dialect | ||
https://sql-on-fhir.org/ig/CodeSystem/SQLContentTypeCodes | application/sql;dialect=mysql | MySQL | SQL content using MySQL dialect | ||
https://sql-on-fhir.org/ig/CodeSystem/SQLContentTypeCodes | application/sql;dialect=oracle | Oracle SQL | SQL content using Oracle dialect | ||
https://sql-on-fhir.org/ig/CodeSystem/SQLContentTypeCodes | application/sql;dialect=postgresql | PostgreSQL | SQL content using PostgreSQL dialect | ||
https://sql-on-fhir.org/ig/CodeSystem/SQLContentTypeCodes | application/sql;dialect=presto | Presto | SQL content using Presto dialect | ||
https://sql-on-fhir.org/ig/CodeSystem/SQLContentTypeCodes | application/sql;dialect=redshift | Amazon Redshift | SQL content using Amazon Redshift dialect | ||
https://sql-on-fhir.org/ig/CodeSystem/SQLContentTypeCodes | application/sql;dialect=snowflake | Snowflake | SQL content using Snowflake dialect | ||
https://sql-on-fhir.org/ig/CodeSystem/SQLContentTypeCodes | application/sql;dialect=spark-sql | Spark SQL | SQL content using Apache Spark SQL dialect | ||
https://sql-on-fhir.org/ig/CodeSystem/SQLContentTypeCodes | application/sql;dialect=sql-2 | SQL-2 | SQL content using SQL-2 dialect | ||
https://sql-on-fhir.org/ig/CodeSystem/SQLContentTypeCodes | application/sql;dialect=sql-server | SQL Server | SQL content using Microsoft SQL Server dialect | ||
https://sql-on-fhir.org/ig/CodeSystem/SQLContentTypeCodes | application/sql;dialect=sqlite | SQLite | SQL content using SQLite dialect | ||
https://sql-on-fhir.org/ig/CodeSystem/SQLContentTypeCodes | application/sql;dialect=teradata | Teradata | SQL content using Teradata dialect | ||
https://sql-on-fhir.org/ig/CodeSystem/SQLContentTypeCodes | application/sql;dialect=trino | Trino | SQL content using Trino dialect | ||
https://sql-on-fhir.org/ig/CodeSystem/SQLContentTypeCodes | application/sql;dialect=vertica | Vertica | SQL content using Vertica dialect |
Explanation of the columns that may appear on this page:
| Level | A few code lists that FHIR defines are hierarchical - each code is assigned a level. In this scheme, some codes are under other codes, and imply that the code they are under also applies |
| System | The source of the definition of the code (when the value set draws in codes defined elsewhere) |
| Code | The code (used as the code in the resource instance) |
| Display | The display (used in the display element of a Coding). If there is no display, implementers should not simply display the code, but map the concept into their application |
| Definition | An explanation of the meaning of the concept |
| Comments | Additional notes about how to use the code |