Enum DialectType 

pub enum DialectType {
    Generic,
    PostgreSQL,
    MySQL,
    BigQuery,
    Snowflake,
    DuckDB,
    SQLite,
    Hive,
    Spark,
    Trino,
    Presto,
    Redshift,
    TSQL,
    Oracle,
    ClickHouse,
    Databricks,
    Athena,
    Teradata,
    Doris,
    StarRocks,
    Materialize,
    RisingWave,
    SingleStore,
    CockroachDB,
    TiDB,
    Druid,
    Solr,
    Tableau,
    Dune,
    Fabric,
    Drill,
    Dremio,
    Exasol,
}

Enumeration of all supported SQL dialects.

Each variant corresponds to a specific SQL database engine or query language. The Generic variant represents standard SQL with no dialect-specific behavior, and is used as the default when no dialect is specified.

Dialect names are case-insensitive when parsed from strings via [FromStr]. Some dialects accept aliases (e.g., “mssql” and “sqlserver” both resolve to TSQL).

Variants

Generic

Standard SQL with no dialect-specific behavior (default).

PostgreSQL

PostgreSQL – advanced open-source relational database.

MySQL

MySQL – widely-used open-source relational database (also accepts “mysql”).

BigQuery

Google BigQuery – serverless cloud data warehouse with unique syntax (backtick quoting, STRUCT types, QUALIFY).

Snowflake

Snowflake – cloud data platform with QUALIFY clause, FLATTEN, and variant types.

DuckDB

DuckDB – in-process analytical database with modern SQL extensions.

SQLite

SQLite – lightweight embedded relational database.

Hive

Apache Hive – data warehouse on Hadoop with HiveQL syntax.

Spark

Apache Spark SQL – distributed query engine (also accepts “spark2”).

Trino

Trino – distributed SQL query engine (formerly PrestoSQL).

Presto

PrestoDB – distributed SQL query engine for big data.

Redshift

Amazon Redshift – cloud data warehouse based on PostgreSQL.

TSQL

Transact-SQL (T-SQL) – Microsoft SQL Server and Azure SQL (also accepts “mssql”, “sqlserver”).

Oracle

Oracle Database – commercial relational database with PL/SQL extensions.

ClickHouse

ClickHouse – column-oriented OLAP database for real-time analytics.

Databricks

Databricks SQL – Spark-based lakehouse platform with QUALIFY support.

Athena

Amazon Athena – serverless query service (hybrid Trino/Hive engine).

Teradata

Teradata – enterprise data warehouse with proprietary SQL extensions.

Doris

Apache Doris – real-time analytical database (MySQL-compatible).

StarRocks

StarRocks – sub-second OLAP database (MySQL-compatible).

Materialize

Materialize – streaming SQL database built on differential dataflow.

RisingWave

RisingWave – distributed streaming database with PostgreSQL compatibility.

SingleStore

SingleStore (formerly MemSQL) – distributed SQL database (also accepts “memsql”).

CockroachDB

CockroachDB – distributed SQL database with PostgreSQL compatibility (also accepts “cockroach”).

TiDB

TiDB – distributed HTAP database with MySQL compatibility.

Druid

Apache Druid – real-time analytics database.

Solr

Apache Solr – search platform with SQL interface.

Tableau

Tableau – data visualization platform with its own SQL dialect.

Dune

Dune Analytics – blockchain analytics SQL engine.

Fabric

Microsoft Fabric – unified analytics platform (T-SQL based).

Drill

Apache Drill – schema-free SQL query engine for big data.

Dremio

Dremio – data lakehouse platform with Arrow-based query engine.

Exasol

Exasol – in-memory analytic database.

Trait Implementations

impl Clone for DialectType

fn clone(&self) -> DialectType

Returns a duplicate of the value.

fn clone_from(&mut self, source: &Self)

Performs copy-assignment from source.

impl Debug for DialectType

fn fmt(&self, f: &mut Formatter<'_>) -> Result

Formats the value using the given formatter.

impl Default for DialectType

fn default() -> Self

Returns the “default value” for a type.

impl<'de> Deserialize<'de> for DialectType

fn deserialize<__D>(__deserializer: __D) -> Result<Self, __D::Error>

where __D: Deserializer<'de>,

Deserialize this value from the given Serde deserializer.

impl Display for DialectType

fn fmt(&self, f: &mut Formatter<'_>) -> Result

Formats the value using the given formatter.

impl FromStr for DialectType

type Err = Error

The associated error which can be returned from parsing.

fn from_str(s: &str) -> Result<Self>

Parses a string s to return a value of this type.

impl Hash for DialectType

fn hash<__H: Hasher>(&self, state: &mut __H)

Feeds this value into the given Hasher.

fn hash_slice<H>(data: &[Self], state: &mut H)

where H: Hasher, Self: Sized,

Feeds a slice of this type into the given Hasher.

impl PartialEq for DialectType

fn eq(&self, other: &DialectType) -> bool

Tests for self and other values to be equal, and is used by ==.

fn ne(&self, other: &Rhs) -> bool

Tests for !=. The default implementation is almost always sufficient, and should not be overridden without very good reason.

impl Serialize for DialectType

fn serialize<__S>(&self, __serializer: __S) -> Result<__S::Ok, __S::Error>

where __S: Serializer,

Serialize this value into the given Serde serializer.

impl Copy for DialectType

impl Eq for DialectType

impl StructuralPartialEq for DialectType