Enum Dialect 

pub enum Dialect {
    SQLite,
    PostgreSQL,
    MySQL,
}

SQL dialect for database-specific behavior

This enum represents the supported SQL database dialects in Drizzle ORM. Each dialect has different placeholder syntax, type mappings, and SQL generation rules.

Examples

use drizzle_types::Dialect;

let dialect = Dialect::PostgreSQL;
assert!(dialect.uses_numbered_placeholders());

let sqlite = Dialect::SQLite;
assert!(!sqlite.uses_numbered_placeholders());

Variants

SQLite

SQLite - uses ? positional placeholders

Compatible with: rusqlite, libsql, turso

PostgreSQL

PostgreSQL - uses $1, $2, ... numbered placeholders

Compatible with: tokio-postgres, postgres, sqlx

MySQL

MySQL - uses ? positional placeholders

Compatible with: mysql, sqlx

Implementations

impl Dialect

pub const fn uses_numbered_placeholders(&self) -> bool

Returns true if this dialect uses numbered placeholders ($1, $2, ...)

Currently only PostgreSQL uses numbered placeholders. SQLite and MySQL use positional ? placeholders.

pub fn parse(s: &str) -> Option<Self>

Parse a dialect from a string (case-insensitive)

Supports various common aliases:

• SQLite: "sqlite", "turso", "libsql"
• PostgreSQL: "postgresql", "postgres", "pg"
• MySQL: "mysql"

Examples

use drizzle_types::Dialect;

assert_eq!(Dialect::parse("sqlite"), Some(Dialect::SQLite));
assert_eq!(Dialect::parse("postgres"), Some(Dialect::PostgreSQL));
assert_eq!(Dialect::parse("pg"), Some(Dialect::PostgreSQL));
assert_eq!(Dialect::parse("unknown"), None);

pub const fn table_prefix(&self) -> &'static str

Get the table attribute prefix for this dialect in generated code

Used by schema parsers and code generators.

pub const fn index_prefix(&self) -> &'static str

Get the index attribute prefix for this dialect in generated code

pub const fn schema_derive(&self) -> &'static str

Get the schema derive attribute for this dialect

pub const fn as_str(&self) -> &'static str

Get the dialect name as a lowercase string

Trait Implementations

impl Clone for Dialect

fn clone(&self) -> Dialect

Returns a duplicate of the value.

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

Performs copy-assignment from source.

impl Debug for Dialect

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

Formats the value using the given formatter.

impl Default for Dialect

fn default() -> Dialect

Returns the “default value” for a type.

impl Display for Dialect

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

Formats the value using the given formatter.

impl FromStr for Dialect

type Err = DialectParseError

The associated error which can be returned from parsing.

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

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

impl Hash for Dialect

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 Dialect

fn eq(&self, other: &Dialect) -> 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 Copy for Dialect

impl Eq for Dialect

impl StructuralPartialEq for Dialect