kyleconroy/sqlc
Sqlc
sqlc is a SQL compiler and code generator that creates type-safe database client code from raw SQL queries. It transforms SQL statements into typed definitions and functions, eliminating the need for manual row mapping between database results and application structures.
The tool ensures compile-time safety by validating SQL queries against the database schema before the application is run. This workflow integrates the database schema directly into the application code, deriving types from the underlying SQL definitions to prevent runtime errors.
The system utilizes AST-based query analysis and dialect-specific parsers to handle various SQL flavors. It employs schema-driven type inference and template-based code generation to produce the final source code.
Features
- Type-Safe Client Generators - Generates type-safe database client code from SQL queries to eliminate manual row mapping.
- Type-Safe - Compiles raw SQL queries into strongly-typed application code to eliminate manual data mapping.
- SQL-to-Language Generators - Transforms raw SQL statements into typed definitions and functions for various programming languages.
- Type-Safe Database Clients - Ensures compile-time safety by generating strongly-typed interfaces for all database operations.
- SQL Schema Integrations - Connects application code to database schemas by deriving types directly from SQL definitions.
- Schema-Driven Type Inference - Automatically derives language-specific type definitions by analyzing the database schema and query projections.
- SQL Query Validators - Verifies that SQL queries are syntactically and structurally correct against the database schema during compilation.
- SQL Abstract Syntax Tree Parsing - Parses raw SQL queries into abstract syntax trees for structural analysis and type inference.
- SQL Dialect Adapters - Provides distinct parsing logic to handle unique syntax variations across different SQL database dialects.
- SQL-to-Code Workflows - Automates the process of turning raw SQL queries into corresponding typed functions and structures.
- Source Code Templates - Injects inferred types and query parameters into templates to produce final type-safe source code.
- SQL Query Builders - Tool to generate type-safe code from SQL.
- Code Generation Tools - Generates type-safe Go code from SQL.
