Most efficient way to store ROQL results into an array

Content

Hi,

So - we need to issue a ROQL query but rather than looping through every single record, we'd like to dump the results straight into an array, kind of how GetRows works with Classic ASP (https://www.w3schools.com/asp/met_rs_getrows.asp). In raw PHP I think you'd do the fetch_all command (http://php.net/manual/de/mysqli-result.fetch-all.php)

What's the best way to do this? Is there no other way to do it other than looping through every single row and appending the values to an array?

Thanks,

JJ