SQL on FHIR
2.1.0-pre - release
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
Draft as of 2025-07-31 |
<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>