{"repo":"arthurkushman/buildsqlx","free":true,"listed":false,"github":"https://github.com/arthurkushman/buildsqlx","clone":"git clone https://github.com/arthurkushman/buildsqlx.git","description":"Go database query builder library for PostgreSQL","language":"Go","stars":188,"topics":["query-builder","sql","postgresql","active-record","golang-library","dml","ddl","clauses","database-table","transactions"],"license":"MIT","category":"databases-storage","readme_excerpt":"buildsqlx Go Database query builder library Installation Selects, Ordering, Limit & Offset GroupBy / Having Where, AndWhere, OrWhere clauses WhereIn / WhereNotIn WhereNull / WhereNotNull Left / Right / Cross / Inner / Left Outer Joins Inserts Updates Delete Drop, Truncate, Rename Increment & Decrement Union / Union All Transaction mode Dump, Dd Check if table exists Check if columns exist in a table within schema Retrieving A Single Row / Column From A Table WhereExists / WhereNotExists Determining If Records Exist Aggregates Create table Add / Modify / Drop columns Chunking Results Pluck / PluckMap Installation Selects, Ordering, Limit & Offset You may not always want to select all columns from a database table. Using the select method, you can specify a custom select clause for the query: InRandomOrder GroupBy / Having The GroupBy and Having methods may be used to group the query results. The having method's signature is similar to that of the Where method: Where, AndWhere, OrWhere clauses You may use the Where method on a query builder instance to add where clauses to the query. The most basic call to where requires three arguments. The first argument is the name of the column. The second argument is an operator, which can be any of the database's supported operators. Finally, the third argument is the value to evaluate against the column. You may chain where constraints together as well as add or clauses to the query. The OrWhere method accepts the same arguments as the W","default_branch":null,"files":null,"tree":[],"storefront":"/r/arthurkushman","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/arthurkushman/buildsqlx/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."}