What are some examples of using Go Query Builder?

Can you provide some examples of how to use Go Query Builder?

Sure! Go Query Builder is a powerful tool for building SQL queries in Go. For example, you can create a simple SELECT query like this:

import "github.com/yourusername/go-query-builder"

qb := querybuilder.New()
qb.Select("name", "age").From("users").Where("age > ?", 18)
query, args := qb.Build()
// query will be "SELECT name, age FROM users WHERE age > ?"
// args will be []interface{}{18}

What about inserting data?

To insert data, you can use the following example:

qb.InsertInto("users").Columns("name", "age").Values("John Doe", 30)
query, args := qb.Build()
// query will be "INSERT INTO users (name, age) VALUES (?, ?)"
// args will be []interface{}{"John Doe", 30}

Can I update records as well?

Absolutely! Here's how you can update a record:

qb.Update("users").Set("age", 31).Where("name = ?", "John Doe")
query, args := qb.Build()
// query will be "UPDATE users SET age = ? WHERE name = ?"
// args will be []interface{}{31, "John Doe"}

What about deleting records?

You can delete records using a similar approach:

qb.DeleteFrom("users").Where("age < ?", 18)
query, args := qb.Build()
// query will be "DELETE FROM users WHERE age < ?"
// args will be []interface{}{18}