sqlb is a simple and expressive SQLBuilder for Rust for sqlx focused on PostgreSQL (for now).

• Simple - Focused on providing an expressive, composable, and reasonably typed scheme to build and execute (via sqlx for now) parameterized SQL statements. The goal is NOT to abstract SQL but to make it expressive and composable using Rust programmatic constructs.
  • NOT a database executor/driver (Will be using sqlx as sql executore)
  • NOT an ORM, just a sql builder.
  • NOT a full replacement for sqlx. Dropping into sqlx when sqlb is too limiting is a valid pattern.
• Expressive - From arbitrary typed data in and out (list of names/values) to struct and mapping rules.
• Focused
  • sqlx - The first "database executor" provided will be sqlx.
  • PostgreSQL - First database support will be Postgres (via sqlx). Additional database support may be added based on interest and pull requests.
• Prepared Statement ONLY!

NOTE: SQL Builders are typically not used directly by application business logic, but rather to be wrapped in some Application Model Access Layer (e.g., DAOs or MCs - Model Controller -). Even when using ORMs, it is often a good code design to wrap those access via some data access layers.

Goals for first 0.x.x releases:

• sqlx - Only plan to be on top of sqlx.
• PostgreSQL - Focus only on PostgreSQL.
• Macros - Adding macros to keep things DRY (but they are optional. All can be implemented via trait objects)
• limitations - Currently, to make types work with sqlb they must implementsqlb::SqlxBindable trait. The aim is to implement SqlxBindable for all sqlx types and allowing app code to implement SqlxBindable for their specific types. If there are any external types that should be supported but are not currently, please feel free to log a ticket.

Early API Example (just conceptual for now)

``rust //sqlx::FromRowallows to do sqlx_exec::fetch_as... //sqlb::Fieldsallows to have: // -toto.fields()(name, value)[] (only direct or NOT Not values) // -Todo::field_names()here would return["id", "title"]`

[derive(sqlx::FromRow, sqlb::Fields)]

pub struct Todo { id: i64,

title: String,
desc: Option<String>,

#[skip_field]
someting_else: String,

}

[derive(sqlb::Fields)]

pub struct TodoForCreate { title: String, desc: Option,

#[skip_field]
someting_else: String,

}

[derive(sqlb::Fields)]

pub struct TodoForUpdate { title: Option, desc: Option, }

// -- Create new row let todoc = TodoForCreate { title: "title 01".tostring(), desc: "desc 01".tostring() }; // will update all fields specified in TodoForCreate let sb = sqlb::insert().table("todo").data(todoc.allfields()); let sb = sb.returning(&["id", "title"]); let (id, title) = sb.fetchone::<_, (i64, String)>(&dbpool).await?;

// -- Select let sb = sqlb::select().table("todo").columns(Todo::fieldnames()).orderby("!id"); let todos: Vec = sb.fetchasall(&db_pool).await?;

// -- Update let todou - TodoForUpdate { desc: "Updated desc 01".tostring()}; let sb = sqlb::update().table("todo").data(todou.notnonefields()).andwhereeq("id", 123); let rowaffected = sb.exec(&db_pool).await?; // will not update .title because of the use of .not_none_fields(). ```

Latest Breaking Changes

• 0.3.0
  • ! CHANGE - HasFields.fields has been rename to HasFields.not_none_fields().
  • + - HasFields.all_fields() - returns all fields (even the one where value are None).
  • + - HasFields::field_names(): &'static [&'static] - list of field names (i.e., column names).
  • + - Added SqlxBindable for the Option<T> (not a blanket impl at this point).
• 0.2.0 - Changing the generic order to match sqlx. From .fetch_one::<(i64, String), _> to .fetch_one::<_, (i64, String)>
• 0.0.7 - sqlb::insert().table("todo") (in 0.0.7) rather than sqlb::insert("toto") (<=0.0.6) (for all SqlBuilders)

For sqlb Dev

Start a PostgreSQL

```sh

In terminal 1 - start postges

docker run --rm --name pg -p 5432:5432 -e POSTGRES_PASSWORD=welcome postgres:14

In terminal 2 - (optional) launch psql on the Postgres instance above

docker exec -it -u postgres pg psql

In terminal 3 -

cargo test

or watch a particular test target

cargo watch -q -c -x 'test --test testsbinsert ```