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

: SQL Dialects Code System - XML Representation

Draft as of 2025-07-31

Raw xml | Download


<CodeSystem xmlns="http://hl7.org/fhir">
  <id value="SQLDialectCodes"/>
  <text>
    <status value="generated"/>
    <div xmlns="http://www.w3.org/1999/xhtml"><p class="res-header-id"><b>Generated Narrative: CodeSystem SQLDialectCodes</b></p><a name="SQLDialectCodes"> </a><a name="hcSQLDialectCodes"> </a><p>This  code system <code>https://sql-on-fhir.org/ig/CodeSystem/SQLDialectCodes</code> defines the following codes:</p><table class="codes"><tr><td style="white-space:nowrap"><b>Code</b></td><td><b>Display</b></td><td><b>Definition</b></td></tr><tr><td style="white-space:nowrap">ansi-sql<a name="SQLDialectCodes-ansi-sql"> </a></td><td>ANSI SQL</td><td>American National Standards Institute SQL standard</td></tr><tr><td style="white-space:nowrap">bigquery<a name="SQLDialectCodes-bigquery"> </a></td><td>BigQuery</td><td>Google BigQuery SQL dialect</td></tr><tr><td style="white-space:nowrap">clickhouse<a name="SQLDialectCodes-clickhouse"> </a></td><td>ClickHouse</td><td>ClickHouse database SQL dialect</td></tr><tr><td style="white-space:nowrap">db2<a name="SQLDialectCodes-db2"> </a></td><td>IBM DB2</td><td>IBM DB2 database SQL dialect</td></tr><tr><td style="white-space:nowrap">duckdb<a name="SQLDialectCodes-duckdb"> </a></td><td>DuckDB</td><td>DuckDB database SQL dialect</td></tr><tr><td style="white-space:nowrap">h2<a name="SQLDialectCodes-h2"> </a></td><td>H2</td><td>H2 database SQL dialect</td></tr><tr><td style="white-space:nowrap">hive<a name="SQLDialectCodes-hive"> </a></td><td>Hive</td><td>Apache Hive dialect</td></tr><tr><td style="white-space:nowrap">hsqldb<a name="SQLDialectCodes-hsqldb"> </a></td><td>HSQLDB</td><td>HyperSQL dialect</td></tr><tr><td style="white-space:nowrap">mariadb<a name="SQLDialectCodes-mariadb"> </a></td><td>MariaDB</td><td>MariaDB database SQL dialect</td></tr><tr><td style="white-space:nowrap">mysql<a name="SQLDialectCodes-mysql"> </a></td><td>MySQL</td><td>MySQL database SQL dialect</td></tr><tr><td style="white-space:nowrap">oracle<a name="SQLDialectCodes-oracle"> </a></td><td>Oracle SQL</td><td>Oracle database SQL dialect</td></tr><tr><td style="white-space:nowrap">postgresql<a name="SQLDialectCodes-postgresql"> </a></td><td>PostgreSQL</td><td>PostgreSQL database SQL dialect</td></tr><tr><td style="white-space:nowrap">presto<a name="SQLDialectCodes-presto"> </a></td><td>Presto</td><td>Presto distributed SQL query engine dialect</td></tr><tr><td style="white-space:nowrap">redshift<a name="SQLDialectCodes-redshift"> </a></td><td>Amazon Redshift</td><td>Amazon Redshift SQL dialect</td></tr><tr><td style="white-space:nowrap">snowflake<a name="SQLDialectCodes-snowflake"> </a></td><td>Snowflake</td><td>Snowflake cloud data warehouse SQL dialect</td></tr><tr><td style="white-space:nowrap">spark-sql<a name="SQLDialectCodes-spark-sql"> </a></td><td>Spark SQL</td><td>Apache Spark SQL dialect</td></tr><tr><td style="white-space:nowrap">sql-2<a name="SQLDialectCodes-sql-2"> </a></td><td>SQL Dialect 2</td><td>The SQL dialect is SQL-2</td></tr><tr><td style="white-space:nowrap">sql-server<a name="SQLDialectCodes-sql-server"> </a></td><td>SQL Server</td><td>Microsoft SQL Server SQL dialect</td></tr><tr><td style="white-space:nowrap">sqlite<a name="SQLDialectCodes-sqlite"> </a></td><td>SQLite</td><td>SQLite database SQL dialect</td></tr><tr><td style="white-space:nowrap">teradata<a name="SQLDialectCodes-teradata"> </a></td><td>Teradata</td><td>Teradata database SQL dialect</td></tr><tr><td style="white-space:nowrap">trino<a name="SQLDialectCodes-trino"> </a></td><td>Trino</td><td>Trino distributed SQL query engine dialect</td></tr><tr><td style="white-space:nowrap">vertica<a name="SQLDialectCodes-vertica"> </a></td><td>Vertica</td><td>Vertica analytics database SQL dialect</td></tr></table></div>
  </text>
  <url value="https://sql-on-fhir.org/ig/CodeSystem/SQLDialectCodes"/>
  <version value="2.1.0-pre"/>
  <name value="SQLDialectCodes"/>
  <title value="SQL Dialects Code System"/>
  <status value="draft"/>
  <date value="2025-07-31T21:26:38+00:00"/>
  <publisher value="SQL on FHIR Working Group"/>
  <contact>
    <name value="SQL on FHIR Working Group"/>
    <telecom>
      <system value="url"/>
      <value value="https://sql-on-fhir.org"/>
    </telecom>
  </contact>
  <description value="SQL dialects"/>
  <jurisdiction>
    <coding>
      <system value="http://unstats.un.org/unsd/methods/m49/m49.htm"/>
      <code value="001"/>
      <display value="World"/>
    </coding>
  </jurisdiction>
  <content value="complete"/>
  <count value="22"/>
  <concept>
    <code value="ansi-sql"/>
    <display value="ANSI SQL"/>
    <definition value="American National Standards Institute SQL standard"/>
  </concept>
  <concept>
    <code value="bigquery"/>
    <display value="BigQuery"/>
    <definition value="Google BigQuery SQL dialect"/>
  </concept>
  <concept>
    <code value="clickhouse"/>
    <display value="ClickHouse"/>
    <definition value="ClickHouse database SQL dialect"/>
  </concept>
  <concept>
    <code value="db2"/>
    <display value="IBM DB2"/>
    <definition value="IBM DB2 database SQL dialect"/>
  </concept>
  <concept>
    <code value="duckdb"/>
    <display value="DuckDB"/>
    <definition value="DuckDB database SQL dialect"/>
  </concept>
  <concept>
    <code value="h2"/>
    <display value="H2"/>
    <definition value="H2 database SQL dialect"/>
  </concept>
  <concept>
    <code value="hive"/>
    <display value="Hive"/>
    <definition value="Apache Hive dialect"/>
  </concept>
  <concept>
    <code value="hsqldb"/>
    <display value="HSQLDB"/>
    <definition value="HyperSQL dialect"/>
  </concept>
  <concept>
    <code value="mariadb"/>
    <display value="MariaDB"/>
    <definition value="MariaDB database SQL dialect"/>
  </concept>
  <concept>
    <code value="mysql"/>
    <display value="MySQL"/>
    <definition value="MySQL database SQL dialect"/>
  </concept>
  <concept>
    <code value="oracle"/>
    <display value="Oracle SQL"/>
    <definition value="Oracle database SQL dialect"/>
  </concept>
  <concept>
    <code value="postgresql"/>
    <display value="PostgreSQL"/>
    <definition value="PostgreSQL database SQL dialect"/>
  </concept>
  <concept>
    <code value="presto"/>
    <display value="Presto"/>
    <definition value="Presto distributed SQL query engine dialect"/>
  </concept>
  <concept>
    <code value="redshift"/>
    <display value="Amazon Redshift"/>
    <definition value="Amazon Redshift SQL dialect"/>
  </concept>
  <concept>
    <code value="snowflake"/>
    <display value="Snowflake"/>
    <definition value="Snowflake cloud data warehouse SQL dialect"/>
  </concept>
  <concept>
    <code value="spark-sql"/>
    <display value="Spark SQL"/>
    <definition value="Apache Spark SQL dialect"/>
  </concept>
  <concept>
    <code value="sql-2"/>
    <display value="SQL Dialect 2"/>
    <definition value="The SQL dialect is SQL-2"/>
  </concept>
  <concept>
    <code value="sql-server"/>
    <display value="SQL Server"/>
    <definition value="Microsoft SQL Server SQL dialect"/>
  </concept>
  <concept>
    <code value="sqlite"/>
    <display value="SQLite"/>
    <definition value="SQLite database SQL dialect"/>
  </concept>
  <concept>
    <code value="teradata"/>
    <display value="Teradata"/>
    <definition value="Teradata database SQL dialect"/>
  </concept>
  <concept>
    <code value="trino"/>
    <display value="Trino"/>
    <definition value="Trino distributed SQL query engine dialect"/>
  </concept>
  <concept>
    <code value="vertica"/>
    <display value="Vertica"/>
    <definition value="Vertica analytics database SQL dialect"/>
  </concept>
</CodeSystem>