pike VS goqu

I've also taken a shot at a similar thing (no GUI though!) https://github.com/sashabaranov/pike

> - Write custom query language (YAML or other), generate SQL schema, queries, and Go query interface (xo).

I've also tried to unify this approach with gRPC/Protobuf messages and CRUD operations: https://github.com/sashabaranov/pike/

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