What is Go Query Builder and how can I use it?

What is Go Query Builder and how can I use it?

Go Query Builder is a library that helps you build SQL queries in Go without writing raw SQL. It provides a fluent interface for constructing queries.

Can you show me a simple example of how to use it?

Sure! Here's a basic example:

qb := goqu.New("postgres", db)
query, _, _ := qb.From("users").Select("id", "name").Where(goqu.Ex{"age": 30}).ToSQL()

This will generate a SQL query to select users aged 30.

What databases does it support?

Go Query Builder supports various databases like PostgreSQL, MySQL, SQLite, and others. You can choose the one that fits your project.

Is it easy to integrate with existing projects?

Yes, it's designed to be easy to integrate. You can start using it in your existing Go projects with minimal setup.