ngb-sqlbuilder 0.1.0-alpha1

Human friendly way to build SQL uqery.
Documentation
ngb-sqlbuilder-0.1.0-alpha1 has been yanked.

SQL Builder for tokio-postgres

Example:

fn example(client:tokio_postgres::Client, user_id:i32, limit:i64, offset:i64) {
    let (sql, params) = select(cols(&["u.UserId", "u.Name", "p.Title", "p.Content"]))
        .from("User as u")
        .left_join("Post as p")
        .using_col("UserId")
        .where_col("u.UserId", eq(&user_id))
        .oder_by_cols(&["CreatedAt desc"])
        .limit(&10)
        .offset(&100)
        .build();

    let rows = client.query(&sql, &params).await.unwrap();
}