Enum SqlDialect 

pub enum SqlDialect {
    Sqlite,
    Postgres,
}

The SQL flavor a backend speaks.

Variants

Sqlite

SQLite (and SQLite-compatible backends like D1, Durable Objects).

Postgres

PostgreSQL.

Implementations

impl SqlDialect

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

Renders a positional bind placeholder for parameter n (1-based): ?n on SQLite, $n on Postgres.

pub fn scalar_max(&self) -> &'static str

Scalar two-argument max function: MAX on SQLite, GREATEST on Postgres. Callers must keep the COALESCE wrapping around the arguments — SQLite’s MAX returns NULL if any argument is NULL while Postgres’s GREATEST ignores NULLs; the COALESCE is what makes both backends merge identically. Do not simplify it away.

pub fn text_collate(&self) -> &'static str

Collation suffix appended to text comparisons that must order bytewise (the LWW value-byte tiebreak, pull-sync cursor iteration). Empty on SQLite (TEXT already compares with BINARY collation); COLLATE "C" on Postgres, whose default collation is locale-aware.

pub fn without_rowid(&self) -> &'static str

CREATE TABLE suffix that stores the table clustered by its primary key instead of a synthetic row id: WITHOUT ROWID on SQLite, empty on Postgres.

pub fn null_safe_eq(&self) -> &'static str

Null-safe equality operator: IS on SQLite, IS NOT DISTINCT FROM on Postgres. Both are infix (a <op> b) and treat two NULLs as equal — unlike =, which yields NULL when either side is NULL.

Trait Implementations

impl Clone for SqlDialect

fn clone(&self) -> SqlDialect

Returns a duplicate of the value.

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

Performs copy-assignment from source.

impl Copy for SqlDialect

impl Debug for SqlDialect

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

Formats the value using the given formatter.

impl Eq for SqlDialect

impl PartialEq for SqlDialect

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