go-jet/jet
Jet
Jet is a schema-driven code generation tool and type-safe SQL builder for Go. It introspects database schemas to automatically generate builders and data models, enabling compile-time type checking for table and column references to prevent runtime errors.
The project distinguishes itself through a fluent interface that mirrors native SQL syntax, allowing for the orchestration of complex queries including common table expressions, recursive queries, and nested JSON structures. It further optimizes data retrieval by binding query outputs directly into generated Go structures or raw byte slices to reduce manual scanning overhead.
The library covers a broad range of database operations, including data modification with conflict handling and joined updates, as well as concurrency management through table-level locking. It also provides utilities for result set combinations using union, intersection, and exception operations.
The library includes command-line tooling for schema introspection and provides configuration options to customize generated code and JSON unmarshaling behavior.
Features
- Type-Safe Query Builders - Offers a type-safe SQL builder that provides compile-time validation based on the database schema.
- Schema Introspection - Introspects database schemas to retrieve table and column structures for generating type-safe code.
- Type-Safe Query Construction - Provides a type-safe fluent interface for constructing select queries with filtering, grouping, and pagination.
- Database Schema Mappings - Maps database table columns to generated Go struct fields for seamless data retrieval.
- Database-to-Code Modelers - Generates Go data models directly from the database schema to map raw rows to structured objects.
- Query Result Binding - Binds database query outputs directly into Go structures by matching column names and types to model fields.
- Fluent Interfaces - Provides a fluent interface that uses method chaining to construct SQL statements programmatically.
- Type-Safe Client Generators - Generates type-safe database clients and builders based on the database schema definitions.
- Type-Safe Query References - Uses generated types to validate table and column references during compilation to prevent runtime errors.
- Database Schema Code Generators - Automatically generates Go source files for builders and models by introspecting the database schema.
- Common Table Expressions - Supports the construction of recursive and non-recursive common table expressions to simplify complex queries.
- Direct Result Binding - Binds query results directly to generated models or byte slices to minimize manual scanning and parsing overhead.
- Returning Clauses - Returns modified records immediately after an update operation using a returning clause.
- Nested JSON Builders - Provides a fluent API for building complex, hierarchical JSON structures directly within database queries.
- Structured JSON Retrieval - Retrieves objects or arrays directly from database columns and maps them to structured data formats.
- Duplicate Insert Suppression - Prevents duplicate errors by ignoring inserts or updating existing rows when constraints are violated.
- Inserted Record Retrievers - Retrieves computed values or full rows immediately after an insert operation.
- Multi-Record Insertions - Adds single or multiple records to tables using raw values, models, or results from other queries.
- Record Updating - Modifies existing table rows using type-safe expressions, model mapping, or explicit column sets.
- Row Deletions - Removes records from a table using filters, ordering, and limits, with optional data retrieval.
- Advanced SQL Orchestration - Orchestrates advanced SQL capabilities including recursive queries and nested JSON structures within a fluent interface.
- Recursive CTE Queries - Supports the construction of recursive common table expressions for retrieving hierarchical data.
- Join-Based Updates - Enables updating records in one table based on values or filters from another table using joins.
- Result Set Unions - Implements SQL set operations including union, intersection, and exception to combine results from multiple queries.
- Table Aliases - Implements typed table aliases that preserve column access and enable compile-time checks for self-joins.
- Table-Level Locks - Obtains table-level locks using conflict modes and non-waiting execution to manage concurrent access.
- Database Tools - Listed in the “Database Tools” section of the Awesome Go awesome list.
- SQL Query Builders - Type-safe SQL query framework with object mapping.
