Enum Dialect 

pub enum Dialect {
    Postgres,
    Sqlite,
    Mysql,
}

SQL dialect for generating dialect-specific SQL.

Re-exported from sqlmodel_core to ensure consistency across the ecosystem. A database connection capable of executing queries.

All operations are async and take a Cx context for cancellation/timeout support. Implementations must be Send + Sync for use across async boundaries.

Transaction Support

Use begin or begin_with to start transactions. Transactions must be explicitly committed or rolled back.

Example

// Execute a simple query
let rows = conn.query(&cx, "SELECT * FROM users WHERE id = $1", &[Value::Int(1)]).await?;

// Use a transaction
let mut tx = conn.begin(&cx).await?;
tx.execute(&cx, "INSERT INTO logs (msg) VALUES ($1)", &[Value::Text("action".into())]).await?;
tx.commit(&cx).await?;

SQL dialect enumeration for cross-database compatibility.

Variants

Postgres

PostgreSQL dialect (uses $1, $2 placeholders)

Sqlite

SQLite dialect (uses ?1, ?2 placeholders)

Mysql

MySQL dialect (uses ? placeholders)

Implementations

impl Dialect

pub fn placeholder(self, index: usize) -> String

Generate a placeholder for the given parameter index (1-based).

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

Get the string concatenation operator for this dialect.

pub const fn supports_ilike(self) -> bool

Check if this dialect supports ILIKE.

pub fn quote_identifier(self, name: &str) -> String

Quote an identifier for this dialect.

Properly escapes embedded quote characters by doubling them:

• For Postgres/SQLite: " becomes ""
• For MySQL: ` becomes ``

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 Copy for Dialect

impl Debug for Dialect

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

Formats the value using the given formatter.

impl Default for Dialect

fn default() -> Dialect

Returns the “default value” for a type.

impl Eq for Dialect

impl PartialEq for Dialect

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

Equality operator ==.

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

Inequality operator !=.

impl StructuralPartialEq for Dialect