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/AllSQLDialectCodes | Version: 2.1.0-pre | |||
Draft as of 2025-10-20 | Computable Name: AllSQLDialectCodes |
ValueSet of all codes from SQL Dialect Codes codesystem
References
This value set is not used here; it may be used elsewhere (e.g. specifications and/or implementations that use this content)
https://sql-on-fhir.org/ig/CodeSystem/SQLDialectCodes
version 📦2.1.0-pre
Expansion performed internally based on codesystem SQL Dialects Code System v2.1.0-pre (CodeSystem)
This value set contains 22 concepts
System | Code | Display (en) | JSON | XML |
https://sql-on-fhir.org/ig/CodeSystem/SQLDialectCodes | ansi-sql | ANSI SQL | ||
https://sql-on-fhir.org/ig/CodeSystem/SQLDialectCodes | bigquery | BigQuery | ||
https://sql-on-fhir.org/ig/CodeSystem/SQLDialectCodes | clickhouse | ClickHouse | ||
https://sql-on-fhir.org/ig/CodeSystem/SQLDialectCodes | db2 | IBM DB2 | ||
https://sql-on-fhir.org/ig/CodeSystem/SQLDialectCodes | duckdb | DuckDB | ||
https://sql-on-fhir.org/ig/CodeSystem/SQLDialectCodes | h2 | H2 | ||
https://sql-on-fhir.org/ig/CodeSystem/SQLDialectCodes | hive | Hive | ||
https://sql-on-fhir.org/ig/CodeSystem/SQLDialectCodes | hsqldb | HSQLDB | ||
https://sql-on-fhir.org/ig/CodeSystem/SQLDialectCodes | mariadb | MariaDB | ||
https://sql-on-fhir.org/ig/CodeSystem/SQLDialectCodes | mysql | MySQL | ||
https://sql-on-fhir.org/ig/CodeSystem/SQLDialectCodes | oracle | Oracle SQL | ||
https://sql-on-fhir.org/ig/CodeSystem/SQLDialectCodes | postgresql | PostgreSQL | ||
https://sql-on-fhir.org/ig/CodeSystem/SQLDialectCodes | presto | Presto | ||
https://sql-on-fhir.org/ig/CodeSystem/SQLDialectCodes | redshift | Amazon Redshift | ||
https://sql-on-fhir.org/ig/CodeSystem/SQLDialectCodes | snowflake | Snowflake | ||
https://sql-on-fhir.org/ig/CodeSystem/SQLDialectCodes | spark-sql | Spark SQL | ||
https://sql-on-fhir.org/ig/CodeSystem/SQLDialectCodes | sql-2 | SQL Dialect 2 | ||
https://sql-on-fhir.org/ig/CodeSystem/SQLDialectCodes | sql-server | SQL Server | ||
https://sql-on-fhir.org/ig/CodeSystem/SQLDialectCodes | sqlite | SQLite | ||
https://sql-on-fhir.org/ig/CodeSystem/SQLDialectCodes | teradata | Teradata | ||
https://sql-on-fhir.org/ig/CodeSystem/SQLDialectCodes | trino | Trino | ||
https://sql-on-fhir.org/ig/CodeSystem/SQLDialectCodes | vertica | Vertica |
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 |