ANN: pGenie – a SQL-first code generator for PostgreSQL: no DSLs, no ORMs, no hand-rolled codecs

dnikolovv:

the only changes I would do is be more explicit about the naming (even if that means changing the .Types namespace to .Tables or something more obviously database-related).

I hear you. The Types namespace may ring different meanings to users (like domain-types). Tables however would definitely be wrong, because this namespace holds user-defined types, not tables. Actually during development that namespace was initially called CustomTypes, but then I reduced it for brevity.

Any way, I have several good news on the matter:

1. The codegen is maintained separately from the main codebase as a Dhall program. You can fork it, do whatever tweaks you need and start using it immediately by doing nothing more than referring to your fork in the pGenie project file, as explained in the docs. Also such changes are trivial to handle for LLMs, so you don’t even need to delve into the codebase at all.

2. Although the Haskell codegen doesn’t yet have any configurable parameters, configuration of codegens is supported, so similar opinion-related issues can simply be turned into codegen-specific config options.