This article gives an example of how golang implements sql result set output in json format. To share for your reference, specific as follows:

func getJSON(sqlString string) (string, error) {
    stmt, err := db.Prepare(sqlString)
    if err != nil {
        return nil, err
    }
    defer stmt.Close()
    rows, err := stmt.Query()
    if err != nil {
        return nil, err
    }
    defer rows.Close()
    columns, err := rows.Columns()
    if err != nil {
      return "", err
    }
    count := len(columns)
    tableData := make([]map[string]interface{}, 0)
    values := make([]interface{}, count)
    valuePtrs := make([]interface{}, count)
    for rows.Next() {
      for i := 0; i < count; i++ {
          valuePtrs[i] = &values[i]
      }
      rows.Scan(valuePtrs...)
      entry := make(map[string]interface{})
      for i, col := range columns {
          var v interface{}
          val := values[i]
          b, ok := val.([]byte)
          if ok {
              v = string(b)
          } else {
              v = val
          }
          entry[col] = v
      }
      tableData = append(tableData, entry)
    }
    jsonData, err := json.Marshal(tableData)
    if err != nil {
      return "", err
    }
    fmt.Println(string(jsonData))
    return string(jsonData), nil
}

PS: As for json operation, here are some more practical json online tools for your reference:

Online JSON code inspection, inspection, beautification, formatting tools: http://tools.ofstack.com/code/json

JSON online formatting tools: http://tools.ofstack.com/code/jsonformat

Online XML/JSON interconversion tool: http://tools.ofstack.com/code/xmljson

json code online formatting/beautification/compression/editing/conversion tools: http://tools.ofstack.com/code/jsoncodeformat

Online json compression/escape tool: http://tools.ofstack.com/code/json\_yasuo\_trans

C language style /HTML/CSS/json code Formatting tool: http://tools.ofstack.com/code/ccode\_html\_css\_json

I hope that this article has been helpful in Go language programming.