sqlc-dev/sqlc
Sqlc
sqlc is a code generation tool that compiles raw SQL queries into type-safe application code. By analyzing SQL statements against database schema definitions during the build process, it eliminates the need for manual data mapping and prevents runtime type errors.
The project functions as a schema-aware generator that translates database column types into native language primitives. It distinguishes itself through a modular, plugin-based architecture that allows for the extension of the generation pipeline to support diverse programming languages and custom frameworks beyond its default capabilities.
Beyond basic generation, the tool provides automated validation of SQL queries and schema compatibility, ensuring that database interactions remain consistent with the underlying schema before code is deployed. It also supports the creation of transactional query blocks and strongly-typed update functions to maintain data integrity across application logic.
Features
- Type-Safe - Compiles raw SQL queries into type-safe application code to eliminate manual data mapping and runtime errors.
- Type-Safe Database Clients - Generates strongly-typed interfaces for database operations to eliminate manual data mapping and runtime errors.
- Schema-Driven Code Generators - Generates idiomatic, type-safe application code by cross-referencing SQL queries against database schema definitions.
- SQL Schema Validators - Verifies SQL queries against database schema definitions during the build process to catch breaking changes.
- Schema Compatibility Validators - Verifies SQL queries against database schema definitions during the build process to ensure compatibility and prevent deployment failures.
- Database Automation Tools - Automates the creation of boilerplate-free database interaction code to ensure reliable storage layer communication.
- Type-Safe Client Generators - Creates language-specific code interfaces from SQL queries to prevent runtime type errors.
- Compile-Time Validators - Verifies SQL query validity against database schema definitions during the build process.
- Database Tools - Listed in the “Database Tools” section of the Awesome Go awesome list.
- Databases and Storage - Generates type-safe code from SQL queries.
- Code Generators - Provides a modular, plugin-based system to generate specialized, type-safe database access code for various programming languages.
- SQL Query Execution - Validates SQL statements against the database schema during compilation to confirm syntax and type compatibility.
- Plugin-Based Architectures - Provides a modular architecture allowing external plugins to extend the code generation pipeline.
- Type Mapping Utilities - Translates database column types into native language primitives to ensure type safety in generated code.
- Code Generation Pipelines - Provides extensible build pipelines to produce specialized database access code for various frameworks.
- Code Generation - Enables the addition of custom plugins to the compilation pipeline for specialized code generation.
