Jet
A type-safe SQL builder for Go with code generation, supporting PostgreSQL, MySQL, and SQLite, plus automatic mapping of query results into Go structs.
Jet combines a type-safe SQL builder, code generation, and automatic query-result mapping for Go applications that talk to a relational database. It generates Go types from an existing database schema, then lets code build SELECT, INSERT, UPDATE, DELETE, and WITH statements as type-checked Go expressions rather than raw SQL strings, covering joins, subqueries, window functions, and locking clauses.
It supports PostgreSQL, MySQL, and SQLite directly, and is reported to also work with wire-compatible databases such as CockroachDB and MariaDB. Jet is explicitly not an ORM: it maps query results into Go types without managing entity state or relationships on its own. It requires Go 1.24 or later and is Apache 2.0 licensed.