dynamic select columns with JSONB

[siff-duke]

I need to do following dynamically:

  const selectSQL = sql`
    "Json" -> 'Email' AS "Email",
    "Json" -> 'FullName' AS "FullName",
    "Json" -> 'CurrentRole' AS "CurrentRole",
    "Json" -> 'Roles' AS "Roles",
    "Json" -> 'External' AS "External",
    "Json" -> 'Locked' AS "Locked",
    "Json" -> 'LoginAt' AS "LoginAt"
  `

await sql`
SELECT
  ${selectSQL}
FROM
  ${sql(tablename)}
`

Any suggestions on how to do this from a list of column names e.g. [ "Email", "FullName", etc ]. Not sure how to piece the sql fragments together with the template literals.

Thanks
Duke