Struct RawQueryBuilder 

pub struct RawQueryBuilder { /* private fields */ }

Raw SQL query builder with parameter binding

Implementations

impl RawQueryBuilder

pub fn new(sql: &str) -> Self

Create a new raw query builder

pub fn bind<T: Into<QueryValue>>(self, value: T) -> Self

Add a parameter to the query

pub fn bind_many<T: Into<QueryValue>>(self, values: Vec<T>) -> Self

Add multiple parameters

pub fn build(self) -> (String, Vec<QueryValue>)

Build the final query with parameter substitution

pub async fn execute<T>(self, pool: &PgPool) -> Result<Vec<T>>

where T: for<'r> FromRow<'r, PgRow> + Send + Unpin,

Execute the raw query and map results to a struct

pub async fn execute_first<T>(self, pool: &PgPool) -> Result<Option<T>>

where T: for<'r> FromRow<'r, PgRow> + Send + Unpin,

Execute the raw query and return the first result

pub async fn execute_raw(self, pool: &PgPool) -> Result<u64>

Execute the raw query and return affected row count