Skip to content

Latest commit

 

History

History
34 lines (29 loc) · 1.12 KB

README.md

File metadata and controls

34 lines (29 loc) · 1.12 KB
Raw

sqlstr

A SQL (sqlstr) query builder.

Features

TODO

  • 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 AS u"
  • Support more database dialects (other than Postgres)
    • Postgres
    • MySQL
    • SQLite