users := Select("*").From("users")

active := users.Where(Eq{"deleted_at": nil})

sql, args, err := active.ToSql()

sql == "SELECT * FROM users WHERE deleted_at IS NULL"

stooges := users.Where(Eq{"username": []string{"moe", "larry", "curly", "shemp"}})
three_stooges := stooges.Limit(3)
rows, err := three_stooges.RunWith(db).Query()

// Behaves like:
rows, err := db.Query("SELECT * FROM users WHERE username IN (?,?,?,?) LIMIT 3",
                      "moe", "larry", "curly", "shemp")

if len(q) > 0 {
    users = users.Where("name LIKE ?", fmt.Sprint("%", q, "%"))
}

// StmtCache caches Prepared Stmts for you
dbCache := NewStmtCache(db)

// StatementBuilder keeps your syntax neat
mydb := StatementBuilder.RunWith(dbCache)
select_users := mydb.Select("*").From("users")