database-sql.go

func convertToResult(rows *sql.Rows) (res [][]interface{}, err error) {
	columns, err := rows.Columns()
	if err != nil {
		return nil, err
	}

	values := make([]sql.RawBytes, len(columns))
	args := make([]interface{}, len(values))

	for i := range values {
		args[i] = &values[i]
	}

	for rows.Next() {
		if err := rows.Scan(args...); err != nil {
			return nil, err
		}
		row := []interface{}{}
		for _, col := range values {
			row = append(row, string(col))
		}
		res = append(res, row)
	}

	return res, nil
}