{"repo":"belchior/sql_query_builder","free":true,"listed":false,"github":"https://github.com/belchior/sql_query_builder","clone":"git clone https://github.com/belchior/sql_query_builder.git","description":"Write SQL queries in a simple and composable way","language":"Rust","stars":72,"topics":["query-builder","sql","postgresql","sqlite","mysql"],"license":"MIT","category":"databases-storage","readme_excerpt":"Write SQL queries in a simple and composable way. The main goal is to find the best balance between write idiomatic SQL queries and manage scenarios of complex query composition mixed with conditional clauses. Quick Start Output Feature Flags SQL Query Builder comes with the following optional features: - postgresql enable Postgres syntax - sqlite enable SQLite syntax - mysql enable MySQL syntax You can enable features like How it's works In a simplified way, the lib has an API to allows you to write dynamic queries in a style similar to queries written in pure SQL and the result is a code idiomatic to both Rust and SQL. Additionally, the library will not try to understand what you write in the parameters and in some ways this is good as it removes a lot of verbosity to generate a SQL query, in contrast, debugging tends to be more difficult and silly errors can appear, the library has a debug() method which had a good output to minimize the effort of debugging complex queries. More technically, consecutive calls to the same clause will accumulates values respecting the order of the calls, the two select produce the same SQL query. Methods like limit and offset will override the previous value, the two select is equivalent The library ignores the order between clauses so the two selects will produce the same query You can conditionally add a clause mutating the select Composition Composition is very welcome to write complex queries, this feature makes the library shine Output ","default_branch":null,"files":null,"tree":[],"storefront":"/r/belchior","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/belchior/sql_query_builder/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."}