Struct RawQuery 

pub struct RawQuery<'a, C> { /* private fields */ }

A builder for executing raw SQL queries with parameter binding.

Returned by Database::raw() or Transaction::raw(). Allows constructing safe, parameterized SQL queries that can bypass the standard model-based QueryBuilder when complex SQL features (CTEs, Window Functions, etc.) are needed.

Implementations

impl<'a, C> RawQuery<'a, C>

where C: Connection + Send,

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

where T: 'a + Encode<'a, Any> + Type<Any> + Send + Sync,

Binds a parameter to the query.

Arguments

• value - The value to bind. Must implement sqlx::Encode and sqlx::Type.

pub async fn fetch_all<T>(self) -> Result<Vec<T>, Error>

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

Executes the query and returns all matching rows mapped to type T.

pub async fn fetch_one<T>(self) -> Result<T, Error>

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

Executes the query and returns the first matching row mapped to type T.

pub async fn fetch_optional<T>(self) -> Result<Option<T>, Error>

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

Executes the query and returns the first matching row, or None if not found.

pub async fn fetch_scalar<O>(self) -> Result<O, Error>

where O: for<'r> Decode<'r, Any> + Type<Any> + Send + Unpin,

Executes the query and returns a single scalar value.

Useful for queries like SELECT count(*) ... or SELECT id ....

pub async fn fetch_scalar_optional<O>(self) -> Result<Option<O>, Error>

where O: for<'r> Decode<'r, Any> + Type<Any> + Send + Unpin,

Executes the query and returns a single scalar value, or None if not found.

pub async fn execute(self) -> Result<u64, Error>

Executes the query (INSERT, UPDATE, DELETE) and returns the number of affected rows.