A SQL (sqlstr) query builder.
#![no_std]
and nocore::fmt
- Feature complete
- PostgreSQL commands
- PostgreSQL functions
- comparison
- mathematical
- pattern mathing
- datetime
- text search
- array
- aggregate
- subquery
-
fn count_column(column: &str)
->COUNT(<column>)
-
fn count_column_as(column: &str, alias: &str)
->COUNT(<column>) AS <alias>
-
fn uninon()
->UNION
-
fn uninon_all()
->UNION ALL
-
fn cte_with(name: &str)
->WITH <name> AS ()
- macro utils
-
quoted!("public"."users" AS "u")
->'public'.'users' AS 'u'
-
doublequoted!("public"."users" AS "u")
->"public"."users" AS "u"
-
backquoted!("public"."users" AS "u")
-> "public
.users
ASu
"
-
- Support more database dialects (other than Postgres)
- Postgres
- MySQL
- SQLite