Postgres QueryBuilder

postgres-querybuilder is a tool to help you write dynamic sql queries in rust and make them work with rust-postgres.

Example

rust let client = pool.get().await?; let mut builder = SelectBuilder::new("users"); builder.select("id"); builder.select("email"); builder.where_eq("password", "123456".to_string()); let query = builder.get_query(); let params = builder.get_ref_params(); let stmt = client.prepare(query.as_str()).await?; let rows = client.query(&stmt, &params).await?; let user = rows.first().map(User::from);

TODO

• [ ] Select query
  • [x] choose columns
  • [x] where equal
  • [x] where not equal
  • [ ] or where condition
  • [x] group by
  • [x] limit
  • [x] offset
  • [x] order by
  • [x] WITH query
• [ ] Update query
  • [x] set value
  • [x] where equal
  • [x] where not equal
  • [ ] or where condition
  • [ ] returning
  • [x] WITH query
• [ ] Insert query
• [ ] Delete query
• [ ] from subrequest