Postgres QueryBuilder
postgres-querybuilder
is a tool to help you write dynamic sql queries in rust and make them work with rust-postgres.
Example
let client = pool.get.await?;
let mut builder = new;
builder.select;
builder.select;
builder.where_eq;
let query = builder.get_query;
let params = builder.get_ref_params;
let stmt = client.prepare.await?;
let rows = client.query.await?;
let user = rows.first.map;
TODO
- Select query
- choose columns
- where equal
- where not equal
- or where condition
- group by
- limit
- offset
- order by
-
WITH
query
- Update query
- set value
- where equal
- where not equal
- or where condition
- returning
-
WITH
query
- Insert query
- Delete query
- from subrequest