{"repo":"SeaQL/sea-query","free":true,"listed":false,"github":"https://github.com/SeaQL/sea-query","clone":"git clone https://github.com/SeaQL/sea-query.git","description":"🔱 A dynamic SQL query builder for MySQL, Postgres and SQLite","language":"Rust","stars":1745,"topics":["rust","query-builder","mysql","postgresql","sqlite","sql","database","mariadb","postgres","sqlx"],"license":null,"category":"databases-storage","readme_excerpt":"🔱 A dynamic query builder for MySQL, Postgres and SQLite SeaQuery SeaQuery is a query builder to help you construct dynamic SQL queries in Rust. You can construct expressions, queries and schema as abstract syntax trees using an ergonomic API. We support MySQL, Postgres and SQLite behind a common interface that aligns their behaviour where appropriate. MS SQL Server Support is available under SeaORM X. SeaQuery is written in 100% safe Rust. All workspace crates has #![forbid(unsafe code)] . SeaQuery is the foundation of SeaORM, an async & dynamic ORM for Rust. We provide integration for SQLx, postgres and rusqlite. See examples for usage. If you like what we do, consider starring, commenting, sharing and contributing! Join our Discord server to chat with others in the SeaQL community! Install SeaQuery is very lightweight, all dependencies are optional. Feature flags Macro: derive SQL engine: backend-mysql , backend-postgres , backend-sqlite Type support: with-chrono , with-time , with-json , with-rust decimal , with-bigdecimal , with-uuid , with-ipnetwork , with-mac address , postgres-array , postgres-interval , postgres-vector Usage Table of Content 1. Basics 1. Iden 1. Expression 1. Condition 1. Statement Builders 1. Query Statement 1. Query Select 1. Query Insert 1. Query Update 1. Query Delete 1. Advanced 1. Aggregate Functions 1. Casting 1. Custom Function 1. Schema Statement 1. Table Create 1. Table Alter 1. Table Drop 1. Table Rename 1. Table Truncate 1. Foreign Key C","default_branch":null,"files":null,"tree":[],"storefront":"/r/SeaQL","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/SeaQL/sea-query/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}