gorestapi VS goqu

Go REST API by Zach https://github.com/snowzach/gorestapi

Check out https://github.com/snowzach/gorestapi I use Zap logger because of all the nice functions it has built in. Getting it to render to a format that Google Stackdriver can parse is just a matter of changing the encoder. For HTTP logging, I do override it and include all the HTTP specific fields. See the HTTP middleware I use to render the request in Stackdriver compatible format.

I use pgx with the stdlib wrapper and sqlx. Example code here https://github.com/snowzach/gorestapi

For SQL, I'd probably go with goqu http://doug-martin.github.io/goqu/

I use goqu (https://github.com/doug-martin/goqu)

SQL Builders (think squirrel or goqu)

I've been looking for a package that allows me to build Postgres DDL statements in Golang. I'm currently using Goqu (https://github.com/doug-martin/goqu) for building statements and it works great, however it does not have support for building schemas. Basic things like creating tables, creating indexes. A great one in JavaScript can be found here: (https://knexjs.org/guide/schema-builder.html#essentials) I have been unable to find anything in Go, does anyone know of any packages like this?

Then use something like https://github.com/doug-martin/goqu to build the SQL.

Try this

We've been using goqu and it's super nice! although there are a ton of other query builders that could better fit your use-case.

If the statement is too dynamic to use query parameters I'd ideally use a dynamic query builder rather than concatenating strings. Goqu is a lib like that but I haven't yet used it personally https://github.com/doug-martin/goqu