Struct AdvancedQueryBuilder 

pub struct AdvancedQueryBuilder { /* private fields */ }

Advanced Query Builder with JOIN support

Implementations

impl AdvancedQueryBuilder

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

Create a new advanced query builder

pub fn select(self, fields: &[&str]) -> Self

Select specific fields

pub fn join(self, join_type: JoinType, table: &str, on_condition: &str) -> Self

Add a JOIN clause

pub fn join_alias( self, join_type: JoinType, table: &str, alias: &str, on_condition: &str, ) -> Self

Add a JOIN clause with alias

pub fn where_raw(self, condition: &str, param: QueryValue) -> Self

Add WHERE condition (raw SQL)

pub fn group_by(self, fields: &[&str]) -> Self

Add GROUP BY clause

pub fn having(self, condition: &str, param: QueryValue) -> Self

Add HAVING condition

pub fn with_cte(self, name: &str, query: &str) -> Self

Add a Common Table Expression (CTE)

pub fn window_fn( self, expression: &str, alias: &str, partition_by: &[&str], order_by: &[&str], ) -> Self

Add a window function

pub fn window_fn_with_frame( self, expression: &str, alias: &str, partition_by: &[&str], order_by: &[&str], frame: &str, ) -> Self

Add window function with frame clause

pub fn order_by(self, field: &str, direction: &str) -> Self

Add ORDER BY clause

pub fn limit(self, limit: u32) -> Self

Set LIMIT

pub fn offset(self, offset: u32) -> Self

Set OFFSET

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

Build the complete SQL query

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

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

Execute the advanced query

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

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

Execute and return first result