Hygen vs SQLDelight

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.

SQLDelight generates typesafe Kotlin APIs from SQL statements and checks database schemas, SQL statements, and migrations at compile time. Its IDE features include SQL autocomplete and refactoring support. Documented database dialects include SQLite, MySQL, and PostgreSQL; HSQL and H2 are experimental, while CockroachDB, DB2, and Oracle dialects are listed as third-party options. The JVM connection overview lists MySQL and PostgreSQL, with JDBC and R2DBC variants shown for supported dialects. The project provides a Gradle plugin and extensions for Kotlin coroutines, RxJava, and AndroidX Paging. Its coroutines extension can expose a query as a Flow and emit updated results when the queried data changes. The Gradle verifySqlDelightMigration task applies migrations to stored schema databases and checks whether they reach the latest schema. SQLDelight is open source under the Apache-2.0 license and has a free listing at free, with no paid tiers stated. Its listed platforms are Android, API, iOS, Linux, macOS, web, and Windows.