Proposal: database/sql/driver Execer should support more types

[herenow]

What version of Go are you using (go version)?

go version go1.5 darwin/amd64

What operating system and processor architecture are you using (go env)?

GOARCH="amd64"
GOBIN=""
GOEXE=""
GOHOSTARCH="amd64"
GOHOSTOS="darwin"
GOOS="darwin"
GOPATH="/Users/user/gocode"
GORACE=""
GOROOT="/Users/user/.gvm/gos/go1.5"
GOTOOLDIR="/Users/user/.gvm/gos/go1.5/pkg/tool/darwin_amd64"
GO15VENDOREXPERIMENT=""
CC="clang"
GOGCCFLAGS="-fPIC -m64 -pthread -fno-caret-diagnostics -Qunused-arguments -fmessage-length=0 -fno-common"
CXX="clang++"
CGO_ENABLED="1"

Proposal/issue

I maintain a database/sql driver for crate.io (Crate), at https://github.com/herenow/go-crate

Crate is a "sql" database, it has support for object/json columns, and prepared statements are "baked in", in the sense that it provides us with a REST api to perform our operations, where we pass it our prepared statement and the args/bulk_args. For example:

curl -sSXPOST '127.0.0.1:4200/_sql?pretty' -d@- <<- EOF
{
  stmt: "INSERT INTO logs (metadata) VALUES (?)",
  bulk_args: [
      { count: 1 },
      { count: 2 }
  ]
}
EOF

Currently it doesn't seem possible to support something like:

db.Exec(`INSERT INTO logs (metadata) VALUES (?)`, []map[string]interface{}{...})

Because database/sql/driver only supports []byte, bool, float64, int64, string, time.Time [1], is that right?

Would it make sense for us to add support for any generic interface or allow drivers to provide their own IsValue()? Are there any alternative solutions?

[1]

go/src/database/sql/driver/types.go

Line 180 in 0104a31

case []byte, bool, float64, int64, string, time.Time:

[odeke-em]

/cc @bradfitz

[kardianos]

@herenow No guarantee, but I'd like to do something about this for go1.8.

[kardianos]

This is a dup of #13567 .

[bradfitz]

Thanks. Closing as dup. We'll track in #13567