/cc @bradfitz

I'm thinking maybe create a new interface that drivers can implement. If they do, use it, if not, don't. Should ensure compatibility.

Databases can support non-standard result types. Common ones that are found include arrays, JSON, XML, table valued types, IP addresses, and GIS types.

For scanning custom result types I propose the following changes are made:

package driver

type ScanAssigner interface {
    Rows
    Assign(dest, src interface{}) (ok bool, err error)
}

package sql

// Existing struct
type Rows struct {
    // New field, assigned when Rows is created.
    assigner driver.ScanAssigner
}

// modify existing function, pass new assigner from Rows into convertAssign.
func convertAssign(assigner driver.ScanAssigner, dest, src interface{}) error {
    ok, err := assigner.Assign(dest, src) // Before anything existing.
    if err != nil {
        return err
    }
    if ok {
        return nil
    }
    // Existing function
}

I think the above should allow returning any database supported type. Using any type as input parameters will be another issue.

This would also allow drivers to truly support uint64 values. Discussion about that was shut down in #9373, but the MySQL implementation requires a hack that returns a uint64 value as a string. I'm really hoping that this makes it into Go 1.9.

CL https://golang.org/cl/38533 mentions this issue.