toArray / to_a

Ruby

rel.to_a

TypeScript

rel.toArray()

Problem

Convert a relation to a plain array for further processing or output.

Example: I’ve built my query and now want the results as an array for JSON serialization.

Description

This operator materializes a relation into a plain array of tuples/objects. This is typically the final step in a query chain when you need to work with the results as regular data.

Requirements

None. Works on any relation.

Examples

Ruby

suppliers
  .restrict(city: "Paris")
  .project([:sid, :name])
  .to_a

=> [{:sid=>"S2", :name=>"Jones"}]

TypeScript

suppliers
  .restrict({ city: "Paris" })
  .project(['sid', 'name'])
  .toArray()

// => [{ sid: "S2", name: "Jones" }]

For JSON serialization

Ruby

require 'json'

data = suppliers
  .project([:name, :city])
  .to_a

JSON.generate(data)
# => '[{"name":"Smith","city":"London"},{"name":"Jones","city":"Paris"}]'

TypeScript

const data = suppliers
  .project(['name', 'city'])
  .toArray()

JSON.stringify(data)
// => '[{"name":"Smith","city":"London"},{"name":"Jones","city":"Paris"}]'