bun VS goqu

This way: https://github.com/uptrace/bun, I prefer in all cases with PostgreSQL

https://github.com/uptrace/bun For SQL building.

I use Bun by Uptrace - https://github.com/uptrace/bun

Though, i've would give a try to bun

Bun would be my choice, it spans a nice gap between full ORM and query builder - https://github.com/uptrace/bun

To get started, see the documentation and run examples.

bun and go-pg both seem to work fairly well for these kind of purposes.

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