Struct SqliteGenerator 

pub struct SqliteGenerator;

Trait Implementations

impl SqlGenerator for SqliteGenerator

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

Quote an identifier (table or column name).

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

Generate the parameter placeholder (e.g., $1, ?, @p1) for a given index.

fn fuzzy_operator(&self) -> &str

Get the fuzzy matching operator (ILIKE vs LIKE).

fn bool_literal(&self, val: bool) -> String

Get the boolean literal (true/false vs 1/0).

fn string_concat(&self, parts: &[&str]) -> String

Generate string concatenation expression (e.g. ‘a’ || ‘b’ vs CONCAT(‘a’, ‘b’)).

fn limit_offset(&self, limit: Option<usize>, offset: Option<usize>) -> String

fn json_access(&self, col: &str, path: &[&str]) -> String

Generate JSON access syntax. path components are the keys to traverse. Default implementation returns “col”.“key1”.“key2” (Standard SQL composite).

fn json_contains(&self, col: &str, value: &str) -> String

Generate JSON/Array contains expression. Default implementation returns Postgres-compatible col @> value.

fn json_key_exists(&self, col: &str, key: &str) -> String

Generate JSON key exists expression. Default implementation returns Postgres-compatible col ? 'key'.

fn json_exists(&self, col: &str, path: &str) -> String

JSON_EXISTS - check if path exists in JSON (Postgres 17+, SQL/JSON standard)

fn json_query(&self, col: &str, path: &str) -> String

JSON_QUERY - extract JSON object/array at path (Postgres 17+, SQL/JSON standard)

fn json_value(&self, col: &str, path: &str) -> String

JSON_VALUE - extract scalar value at path (Postgres 17+, SQL/JSON standard)

fn in_array(&self, col: &str, value: &str) -> String

Generate IN array check (col IN value) Default: Postgres-style col = ANY(value) for array params

fn not_in_array(&self, col: &str, value: &str) -> String

Generate NOT IN array check (col NOT IN value) Default: Postgres-style col != ALL(value) for array params