Struct QueryBuilder 

pub struct QueryBuilder<'conn, 'q> { /* private fields */ }

Fluent builder for query execution with optional placeholder translation.

Implementations

impl QueryBuilder<'_, '_>

pub async fn dml(self) -> Result<usize, SqlMiddlewareDbError>

Execute a DML statement and return rows affected.

Errors

Returns an error if placeholder translation fails or the backend DML execution fails.

impl QueryBuilder<'_, '_>

pub async fn select(self) -> Result<ResultSet, SqlMiddlewareDbError>

Execute a SELECT and return the result set.

Errors

Returns an error if placeholder translation fails or the backend query execution fails.

impl<'conn, 'q> QueryBuilder<'conn, 'q>

pub fn params(self, params: &'q [RowValues]) -> Self

Provide parameters for this statement.

pub fn options(self, options: QueryOptions) -> Self

Override translation using QueryOptions.

pub fn translation(self, translation: TranslationMode) -> Self

Override translation mode directly.

Warning: translation skips placeholders inside quoted strings, comments, and dollar-quoted blocks via a lightweight state machine; it may miss edge cases in complex SQL (e.g., PL/pgSQL bodies). Prefer backend-specific SQL instead of relying on translation:

let query = match conn {
    MiddlewarePoolConnection::Postgres { .. } => r#"$function$
BEGIN
    RETURN ($1 ~ $q$[\t\r\n\v\\]$q$);
END;
$function$"#,
    MiddlewarePoolConnection::Sqlite { .. } | MiddlewarePoolConnection::Turso { .. } => {
        include_str!("../sql/functions/sqlite/03_sp_get_scores.sql")
    }
};