Struct RelationalSelectBuilder 

pub struct RelationalSelectBuilder { /* private fields */ }

Builder for relational SELECT queries.

Implementations

impl RelationalSelectBuilder

pub fn new(source_table: &str, columns: &[&str]) -> Self

New builder for the given source table and scalar columns.

pub fn with_many( self, field_name: &str, target_table: &str, local_key: &str, foreign_key: &str, target_columns: &[&str], ) -> Self

Add a has-many relation.

pub fn with_one( self, field_name: &str, target_table: &str, local_key: &str, foreign_key: &str, target_columns: &[&str], ) -> Self

Add a has-one / belongs-to relation.

pub fn relation_configs(&self) -> &[RelationConfig]

Relation configurations in declaration order.

pub fn source_table(&self) -> &str

Source table name.

pub fn source_columns(&self) -> &[String]

Scalar column names on the source table.

impl RelationalSelectBuilder

pub fn to_sql_postgres(&self) -> String

Postgres: LEFT JOIN LATERAL + json_agg / json_build_array.

impl RelationalSelectBuilder

pub fn to_sql_sqlite(&self) -> String

SQLite: correlated subqueries + json_group_array / json_array.

pub fn to_sql(&self) -> String

SQL for the active driver feature (postgres vs default sqlite/libsql).