go: sqldriver doesn't support all possible Arrow types

[amoeba]

What feature or improvement would you like to see?

The Go sqldriver ADBC interface doesn't support the more complex types such as list/map/struct and some more. When users try to return results involving these types, they get this error from Next():

arrow-adbc/go/adbc/sqldriver/driver.go

Lines 741 to 746 in c4f286c

	default:
	return &adbc.Error{
	Code: adbc.StatusNotImplemented,
	Msg: "not yet implemented populating from columns of type " + col.DataType().String(),
	}
	}

And queries like these fail with it,

• SELECT [3, 11, 17] AS my_list_col
• SELECT {'x': 3, 'y': eleven'} AS my_struct_col
• SELECT MAP(['a, 'b'], [3, 11]) AS my_map_col

The workaround for now is to drop down into the low level Go ADBC interfaces (where the types are supported).

[amoeba]

After talking to @zeroshade, the best fix for this is probably handling the conversions in arrow-go. I'll leave this open since it's still valid and may help people who run into this.