do-entity-store

You can generate SQL migration files and sqlc query definitions by specifying the entity and domain name, which creates tables with UUID primary keys, TIMESTAMPTZ timestamps, soft-delete columns, and full CRUD operations following sqlc conventions for required and optional arguments.

The sqlc convention for optional arguments in generated CRUD queries involves applying specific parameter filtering, such as filtering for active records to exclude soft-deleted entries, ensuring queries handle both required and optional arguments correctly in the Go backend.

Yes, you can add foreign key constraints and soft-delete columns when creating SQL schema migrations. The Skill supports generating tables with these constraints, alongside UUID primary keys and TIMESTAMPTZ timestamps, and automatically updates the sqlc.yaml configuration for PostgreSQL.

Yes, this SQL migration generator supports list-by-parent queries for related entities. It generates full CRUD operations, including specialized list-by-parent queries, ensuring you can efficiently retrieve child records mapped to a parent domain entity using sqlc.

You update sqlc.yaml for PostgreSQL automatically when generating new database schemas. The Skill configures the sqlc.yaml file during migration and query generation to ensure the PostgreSQL connection and schema mappings are correctly defined for the new entity.