Parameterized queries with aggregate functions with an array of column names

[vbackeberg]

I would like to wrap my column names with aggregate functions like SUM().

I don't know what the column names are and how many. They are just an array of strings.

I have tried to parse the column names like below, but this will turn the wrapped variable into one big parameter.
I think what is needed here is a way to "spread" the array into the query before the whole variable is parameterized.

const columnNames = ["a", "b"]
const wrapped = columNames.flatMap(cn => `sum(${cn})`).join(", ")
sql`
select ${wrapped}
from tableX
` 

Is this possible?