Package jet is a complete solution for efficient and high performance database access, consisting of type-safe SQL builder with code generation and automatic query result data mapping.
Package builder is a simple and powerful sql builder for Go. Make sure you have installed Go 1.1+ and then: WARNNING: Currently, only query conditions are supported. Below is the supported conditions. 1. Eq is a redefine of a map, you can give one or more conditions to Eq 2. Neq is the same to Eq 3. Gt, Gte, Lt, Lte 4. Like 5. Expr you can customerize your sql with Expr 6. In and NotIn 7. IsNull and NotNull 8. And(conds ...Cond), And can connect one or more condtions via AND 9. Or(conds ...Cond), Or can connect one or more conditions via Or 10. Between 11. define yourself conditions Since Cond is a interface, you can define yourself conditions and compare with them
Package gocqlx is an idiomatic extension to gocql that provides usability features. With gocqlx you can bind the query parameters from maps and structs, use named query parameters (:identifier) and scan the query results into structs and slices. It comes with a fluent and flexible CQL query builder and a database migrations module.
Package jet is a complete solution for efficient and high performance database access, consisting of type-safe SQL builder with code generation and automatic query result data mapping.
Package dnscore provides a DNS resolver, a DNS transport, a query builder, and a DNS response parser.
Package osquery provides a non-obtrusive, idiomatic and easy-to-use query and aggregation builder for the official Go client (https://github.com/elastic/go-elasticsearch) for the ElasticSearch database (https://www.elastic.co/products/elasticsearch). osquery alleviates the need to use extremely nested maps (map[string]interface{}) and serializing queries to JSON manually. It also helps eliminating common mistakes such as misspelling query types, as everything is statically typed. Using `osquery` can make your code much easier to write, read and maintain, and significantly reduce the amount of code you write. osquery provides a method chaining-style API for building and executing queries and aggregations. It does not wrap the official Go client nor does it require you to change your existing code in order to integrate the library. Queries can be directly built with `osquery`, and executed by passing an `*elasticsearch.Client` instance (with optional search parameters). Results are returned as-is from the official client (e.g. `*esapi.Response` objects). Getting started is extremely simple: osquery currently supports version 7 of the ElasticSearch Go client. The library cannot currently generate "short queries". For example, whereas ElasticSearch can accept this: { "query": { "term": { "user": "Kimchy" } } } The library will always generate this: This is also true for queries such as "bool", where fields like "must" can either receive one query object, or an array of query objects. `osquery` will generate an array even if there's only one query object.
Package jet is a complete solution for efficient and high performance database access, consisting of type-safe SQL builder with code generation and automatic query result data mapping. Jet currently supports PostgreSQL, MySQL, MariaDB and SQLite. Future releases will add support for additional databases. Use the command bellow to add jet as a dependency into go.mod project: Jet generator can be installed in one of the following ways: (Go1.16+) Install jet generator using go install: go install github.com/amantuladhar/jet/v2/cmd/jet@latest Install jet generator to GOPATH/bin folder: cd $GOPATH/src/ && GO111MODULE=off go get -u github.com/go-jet/jet/cmd/jet Install jet generator into specific folder: git clone https://github.com/go-jet/jet.git cd jet && go build -o dir_path ./cmd/jet Make sure that the destination folder is added to the PATH environment variable. Jet requires already defined database schema(with tables, enums etc), so that jet generator can generate SQL Builder and Model files. File generation is very fast, and can be added as every pre-build step. Sample command: Before we can write SQL queries in Go, we need to import generated SQL builder and model types: To write postgres SQL queries we import: Then we can write the SQL query: Now we can run the statement and store the result into desired destination: We can print a statement to see SQL query and arguments sent to postgres server: Output: If we print destination as json, we'll get: Detail info about all statements, features and use cases can be found at project wiki page - https://github.com/go-jet/jet/wiki.
Package obreron provides a small SQL query builder for Go.
Package jet is a complete solution for efficient and high performance database access, consisting of type-safe SQL builder with code generation and automatic query result data mapping.
Package jet is a complete solution for efficient and high performance database access, consisting of type-safe SQL builder with code generation and automatic query result data mapping.
goqu an idiomatch SQL builder, and query package.
Package builder is a simple and powerful sql builder for Go. Make sure you have installed Go 1.1+ and then: WARNNING: Currently, only query conditions are supported. Below is the supported conditions. 1. Eq is a redefine of a map, you can give one or more conditions to Eq 2. Neq is the same to Eq 3. Gt, Gte, Lt, Lte 4. Like 5. Expr you can customerize your sql with Expr 6. In and NotIn 7. IsNull and NotNull 8. And(conds ...Cond), And can connect one or more condtions via AND 9. Or(conds ...Cond), Or can connect one or more conditions via Or 10. Between 11. define yourself conditions Since Cond is a interface, you can define yourself conditions and compare with them
gosq is a parsing engine for a simplicity-focused, template-based SQL query builder for Go.
gqb is made for generating a query builder.
Package sqlbuilder is a SQL-query builder for golang.
goqu an idiomatch SQL builder, and query package.
goqu an idiomatch SQL builder, and query package.
Package sqlbuilder is a Standard Query Language builder for golang supporting Sqlite3, MySQL and Postgres
Package esquery provides a non-obtrusive, idiomatic and easy-to-use query and aggregation builder for the official Go client (https://github.com/elastic/go-elasticsearch) for the ElasticSearch database (https://www.elastic.co/products/elasticsearch).
Package influx provides a query builder to ease the writing of query to InfluxDB with the InfluxQL language. After instantiating a new query object with NewQuery, call the different methods to adapt the query to fit your needs. You can call Build to get the InfluxQL query in a string form. Eventually call Do to actually execute the query. Example Usage
Package qb is a simple query builder.
Package pqcomp provides dead simple query builder that support null types from sql package, but also provide interface Appearer.
package osquery provides a non-obtrusive, idiomatic and easy-to-use query and aggregation builder for the official Go client (https://github.com/elastic/go-elasticsearch) for the ElasticSearch database (https://www.elastic.co/products/elasticsearch).
Package goq provides a type-safe and fluent query builder.
Package godb is query builder and struct mapper.