Struct QueryBuilder 

pub struct QueryBuilder<'a> { /* private fields */ }

Query builder for PostgREST database operations.

Provides a fluent API for constructing and executing database queries.

Implementations

impl<'a> QueryBuilder<'a>

pub fn select(self, columns: impl Into<String>) -> Self

Specifies which columns to select.

Pass "*" to select all columns, or a comma-separated list of column names.

pub fn insert<T: Serialize>(self, data: &T) -> Result<Self, Error>

Prepares an insert operation with the provided data.

Data will be serialized to JSON. Call execute() to run the query.

pub fn update<T: Serialize>(self, data: &T) -> Result<Self, Error>

Prepares an update operation with the provided data.

Should be combined with filter methods to target specific rows.

pub fn delete(self) -> Self

Prepares a delete operation.

Should be combined with filter methods to target specific rows.

pub fn eq(self, column: impl Into<String>, value: impl Into<String>) -> Self

Filter: column equals value (col=eq.val).

pub fn neq(self, column: impl Into<String>, value: impl Into<String>) -> Self

Filter: column not equals value (col=neq.val).

pub fn gt(self, column: impl Into<String>, value: impl Into<String>) -> Self

Filter: column greater than value (col=gt.val).

pub fn gte(self, column: impl Into<String>, value: impl Into<String>) -> Self

Filter: column greater than or equal to value (col=gte.val).

pub fn lt(self, column: impl Into<String>, value: impl Into<String>) -> Self

Filter: column less than value (col=lt.val).

pub fn lte(self, column: impl Into<String>, value: impl Into<String>) -> Self

Filter: column less than or equal to value (col=lte.val).

pub fn like(self, column: impl Into<String>, pattern: impl Into<String>) -> Self

Filter: column matches pattern (col=like.pattern).

Use * as wildcard character.

pub fn ilike( self, column: impl Into<String>, pattern: impl Into<String>, ) -> Self

Filter: column matches pattern case-insensitively (col=ilike.pattern).

Use * as wildcard character.

pub fn in_<I, S>(self, column: impl Into<String>, values: I) -> Self

where I: IntoIterator<Item = S>, S: AsRef<str>,

Filter: column value is in the provided list (col=in.(v1,v2,...)).

pub fn is_null(self, column: impl Into<String>) -> Self

Filter: column is null (col=is.null).

pub fn not_null(self, column: impl Into<String>) -> Self

Filter: column is not null (col=not.is.null).

pub fn order(self, column: impl Into<String>) -> Self

Orders results by the specified column.

Use "column" for ascending or "column.desc" for descending.

pub fn limit(self, count: usize) -> Self

Limits the number of rows returned.

pub fn offset(self, count: usize) -> Self

Offsets the results by the specified number of rows.

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

Executes the query and returns the response.