We have both Pure Go and Cgo options available for some SQL Drivers. As a rule of thumb, should I rather choose the Pure Go version in this situation? I mean, what should I consider to choose between a Pure Go and a Cgo version?
You could test if there is a speed difference. Probably not most time is waiting for the database. The number of stars and how active the development seems. When was the last commit.