Struct Sql 

pub struct Sql { /* private fields */ }

A raw SQL query with parameterized values.

Implementations

impl Sql

pub fn new(sql: impl Into<String>) -> Self

Create a new raw SQL query.

pub fn empty() -> Self

Create an empty SQL query.

pub fn with_db_type(self, db_type: DatabaseType) -> Self

Set the database type for parameter formatting.

pub fn push(self, sql: impl Into<String>) -> Self

Append a literal SQL string.

pub fn bind(self, value: impl Into<FilterValue>) -> Self

Bind a parameter value.

pub fn bind_many(self, values: impl IntoIterator<Item = FilterValue>) -> Self

Bind multiple parameter values at once.

pub fn push_if(self, condition: bool, sql: impl Into<String>) -> Self

Append a conditional clause.

pub fn bind_if(self, condition: bool, value: impl Into<FilterValue>) -> Self

Bind a parameter conditionally.

pub fn push_bind( self, sql: impl Into<String>, value: impl Into<FilterValue>, ) -> Self

Push SQL and bind a value together.

pub fn push_bind_if( self, condition: bool, sql: impl Into<String>, value: impl Into<FilterValue>, ) -> Self

Push SQL and bind a value conditionally.

pub fn separated(self, separator: &str) -> SeparatedSql

Add a separator between parts if there are previous parts.

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

Build the final SQL string and parameters.

pub fn sql(&self) -> String

Get the SQL string (without consuming).

pub fn params(&self) -> &[FilterValue]

Get the parameters (without consuming).

pub fn param_count(&self) -> usize

Get the number of bound parameters.

pub fn is_empty(&self) -> bool

Check if the query is empty.

Trait Implementations

impl Clone for Sql

fn clone(&self) -> Sql

Returns a duplicate of the value.

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

Performs copy-assignment from source.

impl Debug for Sql

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

Formats the value using the given formatter.

impl Default for Sql

fn default() -> Self

Returns the “default value” for a type.

impl Display for Sql

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

Formats the value using the given formatter.