buildsqlx

Go database query builder library for PostgreSQL

MIT License

Stars

169

View Code on GitHub

Ecosystems: Go, PostgreSQL

buildsqlx - Add Find() method to retrieve a single row by its id column value

Published by arthurkushman over 3 years ago

buildsqlx - Fix incorrect bindings on strings

Published by arthurkushman almost 4 years ago

buildsqlx - Fix module name in go.mod + readme

Published by arthurkushman over 4 years ago

buildsqlx - Add chunking results processing ability with Chunk method

Published by arthurkushman almost 5 years ago

buildsqlx - Add Rename column, Collation, create index on existing column

Published by arthurkushman about 5 years ago

buildsqlx - Columns addition/modification/deletion + WhereBetween/WhereNotBetween

Published by arthurkushman about 5 years ago

buildsqlx - Add point/polygon and json/jsonb types + minor fixes

Published by arthurkushman about 5 years ago

buildsqlx - Create index/unique/foreign keys, comments for col/tbl, vectors etc

Published by arthurkushman about 5 years ago

index/unique/foreign column keys
comments for columns/table
tsvector/tsquery types for table
date/time/timestamp(datetime)/tz types

buildsqlx - CreateTable with column specific definitions + InRandomOrder

Published by arthurkushman about 5 years ago

buildsqlx - Fix orderBy mixing based on hash-table keys hashing

Published by arthurkushman about 5 years ago

buildsqlx - Add where clause bindings

Published by arthurkushman about 5 years ago

for select queries like Get/First etc
for aggregates like Avg/Sum/Min/Max/Count
for other DML stmts - Update/Delete

buildsqlx - Add where clause bindings

Published by arthurkushman about 5 years ago

for select queries like Get/First etc
for aggregates like Avg/Sum/Min/Max/Count

buildsqlx - Count/Sum/Avg/Min/Max aggregates, Exists/DoesntExists

Published by arthurkushman about 5 years ago

Aggregates Count/Sum/Avg/Min/Max
More specific clauses Exists/DoesntExists

buildsqlx - Pluck/PluckMap + fix builder reset

Published by arthurkushman about 5 years ago

buildsqlx - Add InTransaction/HasTable/HasColumn/First/WhereExists/WhereNotExists

Published by arthurkushman about 5 years ago

InTransaction to execute queries in transaction mode with rollback/commit respectfully
HasTable to check whether the table exists
HasColumn to check whether the columns existent
First to get one row from query result
WhereExists to execute WHERE EXISTS clause within the outer query
WhereNotExists to execute WHERE NOT EXISTS clause within the outer query
tests + minor fixes

buildsqlx - Union / UnionAll + bug fixes

Published by arthurkushman about 5 years ago

buildsqlx - lockForUpdate + Having for GroupBy clauses

Published by arthurkushman about 5 years ago

buildsqlx - FULL OUTER JOIN / INNER JOIN + fixes

Published by arthurkushman about 5 years ago

buildsqlx - Replace + Increment/Decrement

Published by arthurkushman about 5 years ago

buildsqlx - Add UPDATE/DELETE sql DML

Published by arthurkushman about 5 years ago

UPDATE with WHERE/FROM clauses
DELETE with WHERE clause

Package Rankings

Top 6.4% on Proxy.golang.org

Badges

Extracted from project README

Related Projects

gorose

GoRose(go orm), a mini database ORM for golang, which inspired by the famous php framwork laravle...

05 Jan 2018 1,149

go-sqlbuilder

A flexible and powerful SQL string builder library plus a zero-config ORM.

27 Dec 2017 1,188

rql

Resource Query Language for REST

05 Jun 2018 342

sqlz

SQL Query Builder for Go

sequel

Sequel - A Go <-> SQL mapping package

sqlittle

Pure Go SQLite file reader

28 Mar 2018 196

xorm

xorm是一个简单而强大的Go语言ORM库，通过它可以使数据库操作非常简便。本库是基于原版xorm的定制增强版本，为xorm提供类似ibatis的配置文件及动态SQL支持，支持AcitveRec...

22 May 2015 1,552

gorp

Go Relational Persistence - an ORM-ish library for Go

04 Jan 2012 3,735

gendry

a golang library for sql builder

01 Dec 2017 1,616