Struct DeleteQuery 

pub struct DeleteQuery { /* private fields */ }

DELETE query builder

Implementations

impl DeleteQuery

pub fn new() -> DeleteQuery

Create an empty DELETE query

pub fn from_table(self, table: &str) -> DeleteQuery

Set the target table

pub fn where_clause(self, condition: &str) -> DeleteQuery

Add a WHERE condition

Security (v0.2.2 fix C-6)

Calls check_where_injection to detect high-risk patterns.

pub fn where_eq(self, column: &str, value: Value) -> DeleteQuery

Add a column = ? AND condition (P0 fix: parameterized binding)

pub fn where_ne(self, column: &str, value: Value) -> DeleteQuery

Add a column <> ? AND condition

pub fn where_gt(self, column: &str, value: Value) -> DeleteQuery

Add a column > ? AND condition

pub fn where_ge(self, column: &str, value: Value) -> DeleteQuery

Add a column >= ? AND condition

pub fn where_lt(self, column: &str, value: Value) -> DeleteQuery

Add a column < ? AND condition

pub fn where_le(self, column: &str, value: Value) -> DeleteQuery

Add a column <= ? AND condition

pub fn where_like(self, column: &str, pattern: Value) -> DeleteQuery

Add a column LIKE ? AND condition

pub fn where_in(self, column: &str, values: Vec<Value>) -> DeleteQuery

Add a column IN (?, ?, ...) AND condition

pub fn where_between(self, column: &str, low: Value, high: Value) -> DeleteQuery

Add a column BETWEEN ? AND ? AND condition

pub fn where_null(self, column: &str) -> DeleteQuery

Add a column IS NULL AND condition

pub fn where_not_null(self, column: &str) -> DeleteQuery

Add a column IS NOT NULL AND condition

pub fn returning(self, columns: &[&str]) -> DeleteQuery

Set the RETURNING clause (supported by PostgreSQL/SQLite 3.35+)

Returns the specified column values of deleted rows after DELETE. MySQL does not support RETURNING; it is ignored in build() (MySQL style) and under MySQL dialect in build_with_dialect().

pub fn returning_all(self) -> DeleteQuery

Set RETURNING * (return all columns)

pub fn build(self) -> String

Generate SQL

Security (gate 9 fix)

The table name is escaped via quote_ident() and wrapped in backticks, preventing malicious table names containing ` from breaking out.

pub fn build_with_dialect(self, db_type: DbType) -> String

Generate SQL for the specified dialect

pub fn build_with_params(self, db_type: DbType) -> BuiltQuery

Generate parameterized SQL (parameterized query, P0 fix: SQL injection prevention)

WHERE conditions can come from parameterized APIs like where_eq/where_in/where_between, with user input bound as parameters rather than string concatenation.

Trait Implementations

impl Clone for DeleteQuery

fn clone(&self) -> DeleteQuery

Returns a duplicate of the value.

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

Performs copy-assignment from source.

impl Debug for DeleteQuery

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

Formats the value using the given formatter.

impl Default for DeleteQuery

fn default() -> DeleteQuery

Returns the “default value” for a type.