arch-mage / xql Goto Github PK

Looking to add multiple join statements at varying points in a code block.

let mut query = xql::select(["*"]);
query = query.from(xql::join(...));
if true {
    query = query.from(xql::join(...));
}

The problem is that the two joins are now comma separated. What is the proper way of building the following statement by adding the second join later on in the code block?:

"SELECT * FROM person JOIN employee ON person.person_id = employee.person_id JOIN employee_team ON employee.employee_id = employee_team.employee_id"

hi,Do you have a plan to support MSSQL?

so i cant set limit & offset together, maybe we can add a fn pagination(limit, offset) -> Result?

pub fn pagination(self, limit: u32, offset: u32) -> Result<'a> {
        Result {
            data: self.into(),
            limit: Some(clause::Limit(limit)),
            offset: Some(clause::Offset(offset)),
            ..Default::default()
        }
}

Postgres allows for tuple comparison, great for pagination.
WHERE (name, id) > ("bob", 1)
Does xql have a standard method for creating this kind of statement?