{"repo":"go-jet/jet","free":true,"listed":false,"github":"https://github.com/go-jet/jet","clone":"git clone https://github.com/go-jet/jet.git","description":"Type safe SQL builder with code generation and automatic query result data mapping","language":"Go","stars":3777,"topics":["golang","sql","sqlbuilder","postgresql","code-generator","database","sql-query","sql-query-builder","postgres","typesafe"],"license":"Apache-2.0","category":"databases-storage","readme_excerpt":"Jet Jet is a complete solution for efficient and high performance database access, combining a type-safe SQL builder with code generation and automatic query result mapping. Jet currently supports the following database engines: PostgreSQL MySQL SQLite This list is not exclusive, as many other databases implement compatible wire protocols. For example, CockroachDB uses the PostgreSQL wire protocol, and MariaDB is based on the MySQL protocol. Both databases are tested and known to work with Jet. Support for additional databases may be introduced in future releases. Jet is the easiest, and the fastest way to write complex type-safe SQL queries as a Go code and map database query result into complex object composition. [!Note] Jet is not an ORM. Contents - Motivation - Features - Getting Started - Prerequisites - Installation - Quick Start - Generate sql builder and model types - Lets write some SQL queries in Go - Execute query and store result - Benefits - Dependencies - Versioning - License - Support the Project Motivation https://medium.com/@go.jet/jet-5f3667efa0cc Features 1) Auto-generated type-safe SQL Builder. Statements supported: SELECT, SELECT JSON (DISTINCT, FROM, WHERE, GROUP BY, HAVING, ORDER BY, LIMIT, OFFSET, FOR, LOCK IN SHARE MODE, UNION, INTERSECT, EXCEPT, WINDOW, sub-queries) INSERT (VALUES, MODEL, MODELS, QUERY, ON CONFLICT/ON DUPLICATE KEY UPDATE, RETURNING) , UPDATE (SET, MODEL, WHERE, RETURNING) , DELETE (WHERE, ORDER BY, LIMIT, RETURNING) , LOCK (IN, NOW","default_branch":null,"files":null,"tree":[],"storefront":"/r/go-jet","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/go-jet/jet/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."}