Can I request "master detail" query?

[tfiliano]

See this example of query:

select order_id, order_number, order_date, order_amount, order_customer, item_id, item_product, item_qt, item_amount from order join item_ordem on order_id = item_orderid

Can I receive a result like this?

[ {1, 2016122601, "2015-04-24T17:05:08.000Z", 350.25, "JOAO DO NORTE", items:[ {1, 2024, 2, 100.0}, {2, 2028, 1, 200.25} ] ]