Hygen vs sqlc

Hygen is a free, open-source code generator that runs in a project and creates code from templates. Its generators are self-contained, with folder structure defining the commands, and it looks for a local `_templates` directory so templates can stay beside project code. Built-in scaffolds help create generators, including through prompts. Templates use EJS and frontmatter, where a `to` value can set the generated file destination. Generators accept command-line arguments, interactive or multi-step prompts, file creation, and content injection into existing files. Templates can also run shell commands, while actions can select matching files with strings or regular expressions. A documented `--dry` option supports test-running generators. Hygen was built for React, Redux, and Node.js boilerplate but can be used with any technology. It runs on Linux, macOS, and Windows, is MIT licensed, and is distributed through Homebrew, npm, Yarn, npx, and standalone binaries.

sqlc is a free command-line tool that turns SQL queries into type-safe application code. You write queries, run sqlc, and call the generated methods from application code through type-safe interfaces. Its documented database matrix covers MySQL, PostgreSQL, and SQLite. Official generators are available for Go, Kotlin, Python, and TypeScript; Go is stable, while Kotlin, Python, and TypeScript are marked beta for MySQL and PostgreSQL. Plugins allow additional languages, with community plugins listed for C#, F#, Java, PHP, Ruby, Zig, Python, and Rust. The sqlc vet command checks queries against configured rules, and sqlc verify checks whether schema changes break existing queries and generated code. Installation options include prebuilt Linux, macOS, and Windows downloads, package managers, Go, and Docker. sqlc Cloud can create short-lived hosted databases for analysis and linting, with managed databases described as read-only.