JSON Columns

const columns = [
  'id', 
  sql.jsonColumnObject(['data', 'keyA', 'keyB']), 
  sql.jsonColumnText(['data', 'keyA', 'keyB'])
]

const result = await sql.query(sql`
  SELECT ${sql.columns(columns)} FROM "users"
`)

// text: SELECT "id", "data"->'keyA'->'keyB', "data"->'keyA'->>'keyB' FROM "users"
// values: []