aarondl/sqlboiler

Features

• Type-Safe Database Clients - Generates strongly-typed Go interfaces from a database schema to ensure compile-time safety for all database operations.
• ORM Code Generators - Automatically generates database models and boilerplate CRUD code from existing database schemas.
• Schema-Driven Code Generators - Analyzes existing database schemas to produce strongly typed Go structures and query helpers at compile time.
• CRUD Operations - Implements standard insert, update, delete, and retrieve operations via generated methods.
• Data Querying - Constructs database queries using a chainable system of modifiers and finishers for flexible data retrieval.
• Database-to-Code Scaffolding - Generates language-specific data classes and helper methods based on an existing database schema.
• Database ORMs - Functions as a database-first ORM that maps database records to typed Go application objects.
• Database Query Execution - Executes SQL commands and binds results to strongly typed structures using model-specific helpers.
• CRUD Interfaces - Provides automated interfaces for common database record modifications based on generated models.
• Database Schema Mapping - Transforms database tables and views into typed structures using configurable naming and case styles.
• Relationship Mapping - Generates dedicated getter methods and mapping logic based on database foreign key constraints to navigate table associations.
• Chainable Modifier Patterns - Provides a type-safe query builder using a chainable modifier pattern to construct SQL statements without raw strings.
• SQL Query Builders - Implements a chainable modifier system to construct type-safe SQL statements without manual string concatenation.
• Type-Safe Query Builders - Provides a modular system of query modifiers to build SQL queries with compile-time validation and avoid string concatenation.
• Model Generators - Creates strongly typed structures and helper methods by analyzing existing database schemas.
• Template-Based Code Customizers - Allows overriding base templates and applying column filters to control the structure of generated output.
• Soft Deletion - Marks a timestamp in a designated column to hide records from queries.
• Database Lifecycle Hooks - Allows registration of custom functions that trigger automatically before or after database CRUD operations.
• Database Record Querying - Provides a type-safe way to retrieve data from tables using filters and query modifiers.
• Eager Loading - Retrieves related records in a single or recursive set of queries to prevent N+1 performance degradation.
• Application-to-Database Enum Mapping - Converts database enum types into language-specific constants to ensure type safety and eliminate raw strings.
• Model Lifecycle Hooks - Provides mechanisms for triggering custom logic during specific database model events like insert or update.
• Relational Association Mapping - Provides dedicated mapping and getter methods to navigate foreign key relationships between database tables.
• Eager Loading - Implements batch-based eager loading to retrieve related records and prevent N+1 query performance issues.
• Relationship Modeling - Generates dedicated getter methods and mapping logic based on database foreign key constraints.
• Association Definitions - Provides helper methods to manage associations based on foreign key definitions.
• Soft Deletion - Implements soft deletion by marking a timestamp in a designated column to hide records from standard queries.
• Template-Based Code Generators - Uses customizable text templates to transform database metadata into executable Go source code.

Star history