Golang SQL scanner and valuer example

scanner_valuer.go

// QueryParams every key is a query param
type QueryParams map[string]QueryParam

// Scan satisfies SQL scanner interface
func (q *QueryParams) Scan(src interface{}) error {
	b, ok := src.([]byte)
	if !ok {
		return errors.New("type assertion to []byte failed")
	}

	return json.Unmarshal(b, q)
}

// Value satisfies SQL Valuer interface
func (q QueryParams) Value() (driver.Value, error) {
	return json.Marshal(q)
}