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-12-02 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)DefinitionJSONXML
https://sql-on-fhir.org/ig/CodeSystem/SQLDialectCodes  ansi-sqlANSI SQLAmerican National Standards Institute SQL standard
https://sql-on-fhir.org/ig/CodeSystem/SQLDialectCodes  bigqueryBigQueryGoogle BigQuery SQL dialect
https://sql-on-fhir.org/ig/CodeSystem/SQLDialectCodes  clickhouseClickHouseClickHouse database SQL dialect
https://sql-on-fhir.org/ig/CodeSystem/SQLDialectCodes  db2IBM DB2IBM DB2 database SQL dialect
https://sql-on-fhir.org/ig/CodeSystem/SQLDialectCodes  duckdbDuckDBDuckDB database SQL dialect
https://sql-on-fhir.org/ig/CodeSystem/SQLDialectCodes  h2H2H2 database SQL dialect
https://sql-on-fhir.org/ig/CodeSystem/SQLDialectCodes  hiveHiveApache Hive dialect
https://sql-on-fhir.org/ig/CodeSystem/SQLDialectCodes  hsqldbHSQLDBHyperSQL dialect
https://sql-on-fhir.org/ig/CodeSystem/SQLDialectCodes  mariadbMariaDBMariaDB database SQL dialect
https://sql-on-fhir.org/ig/CodeSystem/SQLDialectCodes  mysqlMySQLMySQL database SQL dialect
https://sql-on-fhir.org/ig/CodeSystem/SQLDialectCodes  oracleOracle SQLOracle database SQL dialect
https://sql-on-fhir.org/ig/CodeSystem/SQLDialectCodes  postgresqlPostgreSQLPostgreSQL database SQL dialect
https://sql-on-fhir.org/ig/CodeSystem/SQLDialectCodes  prestoPrestoPresto distributed SQL query engine dialect
https://sql-on-fhir.org/ig/CodeSystem/SQLDialectCodes  redshiftAmazon RedshiftAmazon Redshift SQL dialect
https://sql-on-fhir.org/ig/CodeSystem/SQLDialectCodes  snowflakeSnowflakeSnowflake cloud data warehouse SQL dialect
https://sql-on-fhir.org/ig/CodeSystem/SQLDialectCodes  spark-sqlSpark SQLApache Spark SQL dialect
https://sql-on-fhir.org/ig/CodeSystem/SQLDialectCodes  sql-2SQL Dialect 2The SQL dialect is SQL-2
https://sql-on-fhir.org/ig/CodeSystem/SQLDialectCodes  sql-serverSQL ServerMicrosoft SQL Server SQL dialect
https://sql-on-fhir.org/ig/CodeSystem/SQLDialectCodes  sqliteSQLiteSQLite database SQL dialect
https://sql-on-fhir.org/ig/CodeSystem/SQLDialectCodes  teradataTeradataTeradata database SQL dialect
https://sql-on-fhir.org/ig/CodeSystem/SQLDialectCodes  trinoTrinoTrino distributed SQL query engine dialect
https://sql-on-fhir.org/ig/CodeSystem/SQLDialectCodes  verticaVerticaVertica analytics database SQL 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