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

ValueSet: All SQL Dialect Codes

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)

Logical Definition (CLD)

 

Expansion

Expansion performed internally based on codesystem SQL Dialects Code System v2.1.0-pre (CodeSystem)

This value set contains 22 concepts

SystemCodeDisplay (en)JSONXML
https://sql-on-fhir.org/ig/CodeSystem/SQLDialectCodes  ansi-sqlANSI SQL
https://sql-on-fhir.org/ig/CodeSystem/SQLDialectCodes  bigqueryBigQuery
https://sql-on-fhir.org/ig/CodeSystem/SQLDialectCodes  clickhouseClickHouse
https://sql-on-fhir.org/ig/CodeSystem/SQLDialectCodes  db2IBM DB2
https://sql-on-fhir.org/ig/CodeSystem/SQLDialectCodes  duckdbDuckDB
https://sql-on-fhir.org/ig/CodeSystem/SQLDialectCodes  h2H2
https://sql-on-fhir.org/ig/CodeSystem/SQLDialectCodes  hiveHive
https://sql-on-fhir.org/ig/CodeSystem/SQLDialectCodes  hsqldbHSQLDB
https://sql-on-fhir.org/ig/CodeSystem/SQLDialectCodes  mariadbMariaDB
https://sql-on-fhir.org/ig/CodeSystem/SQLDialectCodes  mysqlMySQL
https://sql-on-fhir.org/ig/CodeSystem/SQLDialectCodes  oracleOracle SQL
https://sql-on-fhir.org/ig/CodeSystem/SQLDialectCodes  postgresqlPostgreSQL
https://sql-on-fhir.org/ig/CodeSystem/SQLDialectCodes  prestoPresto
https://sql-on-fhir.org/ig/CodeSystem/SQLDialectCodes  redshiftAmazon Redshift
https://sql-on-fhir.org/ig/CodeSystem/SQLDialectCodes  snowflakeSnowflake
https://sql-on-fhir.org/ig/CodeSystem/SQLDialectCodes  spark-sqlSpark SQL
https://sql-on-fhir.org/ig/CodeSystem/SQLDialectCodes  sql-2SQL Dialect 2
https://sql-on-fhir.org/ig/CodeSystem/SQLDialectCodes  sql-serverSQL Server
https://sql-on-fhir.org/ig/CodeSystem/SQLDialectCodes  sqliteSQLite
https://sql-on-fhir.org/ig/CodeSystem/SQLDialectCodes  teradataTeradata
https://sql-on-fhir.org/ig/CodeSystem/SQLDialectCodes  trinoTrino
https://sql-on-fhir.org/ig/CodeSystem/SQLDialectCodes  verticaVertica

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