Efficiently Converting Large SQL Data Sets from external api to JSON Format

Hello!

I'm in need of some guidance for converting SQL data from an external API into a JSON format compatible with Xano, without using forEach loops for large datasets (over 1000 entries). The forEach method has proven inefficient and unsuitable for my needs. Here's an example of the JSON structure I'm targeting:

"result": {
  "schema": {
    "fields": [
      {
        "name": "event_date",
        "type": "STRING",
        "mode": "NULLABLE"
      },
      {
        "name": "sessions",
        "type": "INTEGER",
        "mode": "NULLABLE"
      }
    ]
  },
  "totalRows": "25",
  "rows": [
    {
      "f": [
        {
          "v": "20240202"
        },
        {
          "v": "8702"
        }
      ]
    },
    ...
  ]
}

Does anyone have experience or suggestions on tools/methods for efficiently transforming SQL data to this JSON format, suitable for large data sets? Looking for a streamlined process that can handle the conversion swiftly and fit well within the Xano environment.

Appreciate any help or pointers!