A lightweight macro system on top of sqlx, inspired by ormx.
APACHE-2.0 License
sqly is a lightweight macro system on top of sqlx, inspired by ormx.
It works by generating common SQL queries and associated structs at compile time, letting the generated queries be checked and executed by sqlx.
This crate differs from ormx mainly by the added functionality of generating SQL SELECT
queries with support for nested objects through SQL JOIN
clauses. Additionally, sqly::query!
macros can be used to further expand generated queries while still providing compile-time verification.
This functionality is still under development (see Roadmap).
[dependencies.sqly]
version = "0.2.0"
features = ["postgres"]
[dependencies.sqlx]
version = "0.8.0"
default-features = false
features = ["macros", "postgres"]
[profile.dev.package.sqlx-macros]
opt-level = 3
[profile.dev.package.sqly-macros]
opt-level = 3
unchecked
— disable compile-time checking
postgres
— generate queries for PostgreSQL
sqlite
— generate queries for SQLite (not supported)
mysql
— generate queries for MySQL (not supported)
Currently only postgres is supported.
DELETE
queriesINSERT
queriesUPDATE
queries#[derive]
invocationsSELECT
queriessqly::query!
macros to extend generated queries#[sqly(alias)]
attribute and optional override in macros#[sqly(default, from, try_from, flatten)]
attributes for select#[sqly(optional)]
attribute for optional update and insert fields#[sqly(returning)]
attribute for generating SQL RETURNING
clauses#[sqly(foreign)]
attributes for nested objects through SQL JOIN
clauses&[T]
DISTINCT
clause in select