Code Generation

[emil14]

SQL must not be written by hand (but there must be a way to do so, so underlying foundation like db/sql must exist). I like personally idea of "schema-first" sql-based code generations that either connects to DB or read migration files and produce source code as an output. Examples are:

• https://www.prisma.io/ (NodeJS, TS)
• https://github.com/xo/xo (Go)
• https://github.com/volatiletech/sqlboiler (Go)
• https://github.com/doug-martin/goqu (Go)
• https://github.com/go-jet/jet (Go)

Also things like https://github.com/jmoiron/sqlx and could be useful as an alternative when preferred approach (code generation) is not suitable for some reason.