libsqldb VS sq

> My current comfort zone is if I can find a query builder that has enough static typing that it has all of the keywords of my preferred SQL flavor, has prepared statements with placeholders- mainly for safety/security, and basically returns a string when you're done.

Some self-promotion (shameless, I know): https://github.com/lelanthran/libsqldb/tree/v1.0.0-rc2

I'm intending to rewrite it ("the first one is always to throw away" - I put too much unnecessary functionality into it and not enough RDBMS server backends) but I've used it in a few projects (use the latest branch) and am happy with it for postgres or sqlite usage.

See https://github.com/lelanthran/libsqldb/blob/v1.0.0-rc2/src/s... for example usage, but the basic premise is:

1. Send parameterised string to DB.

- generate code from running database and use a type-safe query builder (https://github.com/bokwoon95/go-structured-query)

https://github.com/bokwoon95/go-structured-query plugging my library, which was inspired by jOOQ. Do check it out and see if it fits your needs.

I'm a big fan of go-structured-query. I quite like the code generation of tables from a database schema, as well as the core struct mapper feature both for reads/writes to the database, which keep the domain entities clean of any struct tags.

Interesting. I've been looking at https://github.com/bokwoon95/go-structured-query but I'll have to look at reform too, now. Thanks.