I'd like to take a JSON string representing an object from a 3rd party API and insert it into a MySQL table. The JSON object properties match the table fields 1-to-1. There are several hundred columns in this table/JSON object. And there will be a few dozen rows to insert at any time.
I'd rather not make a huge struct. But if I need to, then I'd rather not
db.Prepare() an INSERT statement with several hundred "?"s. But if I have to then I'd rather not Have to write a
stmt.Exec() with several hundred parameters.
Is there a good way to do this in golang? Or is it just going to be extremely inefficient?