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 |
{
"resourceType" : "CodeSystem",
"id" : "SQLDialectCodes",
"text" : {
"status" : "generated",
"div" : "<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>"
},
"url" : "https://sql-on-fhir.org/ig/CodeSystem/SQLDialectCodes",
"version" : "2.1.0-pre",
"name" : "SQLDialectCodes",
"title" : "SQL Dialects Code System",
"status" : "draft",
"date" : "2025-07-31T21:26:38+00:00",
"publisher" : "SQL on FHIR Working Group",
"contact" : [
{
"name" : "SQL on FHIR Working Group",
"telecom" : [
{
"system" : "url",
"value" : "https://sql-on-fhir.org"
}
]
}
],
"description" : "SQL dialects",
"jurisdiction" : [
{
"coding" : [
{
"system" : "http://unstats.un.org/unsd/methods/m49/m49.htm",
"code" : "001",
"display" : "World"
}
]
}
],
"content" : "complete",
"count" : 22,
"concept" : [
{
"code" : "ansi-sql",
"display" : "ANSI SQL",
"definition" : "American National Standards Institute SQL standard"
},
{
"code" : "bigquery",
"display" : "BigQuery",
"definition" : "Google BigQuery SQL dialect"
},
{
"code" : "clickhouse",
"display" : "ClickHouse",
"definition" : "ClickHouse database SQL dialect"
},
{
"code" : "db2",
"display" : "IBM DB2",
"definition" : "IBM DB2 database SQL dialect"
},
{
"code" : "duckdb",
"display" : "DuckDB",
"definition" : "DuckDB database SQL dialect"
},
{
"code" : "h2",
"display" : "H2",
"definition" : "H2 database SQL dialect"
},
{
"code" : "hive",
"display" : "Hive",
"definition" : "Apache Hive dialect"
},
{
"code" : "hsqldb",
"display" : "HSQLDB",
"definition" : "HyperSQL dialect"
},
{
"code" : "mariadb",
"display" : "MariaDB",
"definition" : "MariaDB database SQL dialect"
},
{
"code" : "mysql",
"display" : "MySQL",
"definition" : "MySQL database SQL dialect"
},
{
"code" : "oracle",
"display" : "Oracle SQL",
"definition" : "Oracle database SQL dialect"
},
{
"code" : "postgresql",
"display" : "PostgreSQL",
"definition" : "PostgreSQL database SQL dialect"
},
{
"code" : "presto",
"display" : "Presto",
"definition" : "Presto distributed SQL query engine dialect"
},
{
"code" : "redshift",
"display" : "Amazon Redshift",
"definition" : "Amazon Redshift SQL dialect"
},
{
"code" : "snowflake",
"display" : "Snowflake",
"definition" : "Snowflake cloud data warehouse SQL dialect"
},
{
"code" : "spark-sql",
"display" : "Spark SQL",
"definition" : "Apache Spark SQL dialect"
},
{
"code" : "sql-2",
"display" : "SQL Dialect 2",
"definition" : "The SQL dialect is SQL-2"
},
{
"code" : "sql-server",
"display" : "SQL Server",
"definition" : "Microsoft SQL Server SQL dialect"
},
{
"code" : "sqlite",
"display" : "SQLite",
"definition" : "SQLite database SQL dialect"
},
{
"code" : "teradata",
"display" : "Teradata",
"definition" : "Teradata database SQL dialect"
},
{
"code" : "trino",
"display" : "Trino",
"definition" : "Trino distributed SQL query engine dialect"
},
{
"code" : "vertica",
"display" : "Vertica",
"definition" : "Vertica analytics database SQL dialect"
}
]
}