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.
