The getCSV function works in a range. I copied (almost verbatim) code from here which loops through the CSV file. An example is {{ range $key, value := getCSV $seperator $filepath }}, but better to find the info I used originally (which I guess was here or I googled it).
About this:
Don’t know how you make sql calls in Hugo. I’d think, depending on the data, it would be easier to convert the sql data to a usable format. If done out of the scope of Hugo, you could use any language you’re familiar with. My go-to language for this kind of thing is PHP, but sql is common enough that I’d assume a variety of languages could handle it.
EDIT: Just noticed post from bep which basciallly says this in a lot less words