SQL on FHIR
2.1.0-pre - release International flag

SQL on FHIR - Local Development build (v2.1.0-pre) built by the FHIR (HL7® FHIR® Standard) Build Tools. See the Directory of published versions

CodeSystem: SQL Dialects Code System

Official URL: https://sql-on-fhir.org/ig/CodeSystem/SQLDialectCodes Version: 2.1.0-pre
Draft as of 2025-10-20 Computable Name: SQLDialectCodes

SQL dialects

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/SQLDialectCodes defines the following codes:

CodeDisplayDefinition
ansi-sql ANSI SQL American National Standards Institute SQL standard
bigquery BigQuery Google BigQuery SQL dialect
clickhouse ClickHouse ClickHouse database SQL dialect
db2 IBM DB2 IBM DB2 database SQL dialect
duckdb DuckDB DuckDB database SQL dialect
h2 H2 H2 database SQL dialect
hive Hive Apache Hive dialect
hsqldb HSQLDB HyperSQL dialect
mariadb MariaDB MariaDB database SQL dialect
mysql MySQL MySQL database SQL dialect
oracle Oracle SQL Oracle database SQL dialect
postgresql PostgreSQL PostgreSQL database SQL dialect
presto Presto Presto distributed SQL query engine dialect
redshift Amazon Redshift Amazon Redshift SQL dialect
snowflake Snowflake Snowflake cloud data warehouse SQL dialect
spark-sql Spark SQL Apache Spark SQL dialect
sql-2 SQL Dialect 2 The SQL dialect is SQL-2
sql-server SQL Server Microsoft SQL Server SQL dialect
sqlite SQLite SQLite database SQL dialect
teradata Teradata Teradata database SQL dialect
trino Trino Trino distributed SQL query engine dialect
vertica Vertica Vertica analytics database SQL dialect