goyesql VS goqu

Write it in a sql file then use a library like https://github.com/knadh/goyesql to load them into a struct. I prefer doing this with all my code. The SQL is also auditable.

sqlc looks very interesting and compelling. A similar library I like but haven't had the chance to really use is goyesql: https://github.com/knadh/goyesql

It also allows just writing SQL in a file, reminds me a bit of JDBI in Java.

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