Converting the Output to JSON

[matton2]

Hello! I just started using this package and has been the easiest to connect and faster responses among the others I have tried. I have a requirement to return the Trino results in JSON format. Is there a way to add the columns to each of the results in data?

Go from this
[ [ "data1" ] ]

To this
[ { 'column1': "data1" } ]

[matton2]

This is not tested but the code could look something like this:

async JsonFormatting(data:any[] |undefined, columnData:any[] |undefined): Promise<any> {

    const rowData = JSON.parse(JSON.stringify(data, (key, value) => typeof value === 'bigint' ? value.toString:value))
    const genObj: any[] = []
    const obj: any[] = JSON.parse(JSON.stringify(genObj))
    let col = JSON.parse(JSON.stringify(columnData))
    for(let i = 0; i < rowData; i++) {
      const row = rowData[i]
      const jsonRow: any = {}
      for (let j = 0; j < row.length; j++) {
        const colName = col[j]
        jsonRow[colName.name] = row[j]
      }
      obj.push(jsonRow)
    }
    obj
  }

  async queryToJson(query: Query | string): Promise<QueryResult> {
    const req = typeof query === 'string' ? {query} : query;
    const headers: RawAxiosRequestHeaders = {
      [TRINO_USER_HEADER]: req.user,
      [TRINO_CATALOG_HEADER]: req.catalog,
      [TRINO_SCHEMA_HEADER]: req.schema,
      [TRINO_SESSION_HEADER]: encodeAsString(req.session ?? {}),
      [TRINO_EXTRA_CREDENTIAL_HEADER]: encodeAsString(
        req.extraCredential ?? {}
      ),
    };
    const requestConfig = {
      method: 'POST',
      url: '/v1/statement',
      data: req.query,
      headers: cleanHeaders(headers),
    };
    return this.request<QueryResult>(requestConfig).then(
      result => this.JsonFormatting(result.data, result.columns)
      )

  }