Sample graph query on SurrealDB

coffeeshop_beverage_prices.sql

-- coffeeshops
CREATE coffeeshop:starbucks SET name='StarBucks';
CREATE coffeeshop:boreal SET name='Boreal';

-- beverages
CREATE beverage:tea SET name='Tea';
CREATE beverage:latte SET name='Latte';
CREATE beverage:caramel_macchiato SET name='Caramel Macchiato';
CREATE beverage:coka_cola SET name='Coka Cola';

-- boreal
RELATE beverage:tea->soldin->coffeeshop:boreal SET price=2.0;
RELATE beverage:latte->soldin->coffeeshop:boreal SET price=3.5;
RELATE beverage:coka_cola->soldin->coffeeshop:boreal SET price=2.5;

-- starbucks
RELATE beverage:tea->soldin->coffeeshop:starbucks SET price=3.5;
RELATE beverage:latte->soldin->coffeeshop:starbucks SET price=4.5;
RELATE beverage:caramel_macchiato->soldin->coffeeshop:starbucks SET price=8.5;

-- select prices of latte
SELECT name, {name: ->soldin->coffeeshop.name, price: ->soldin.price } AS shops FROM beverage:latte;
-- [
--     {
--         "time":"369.625µs",
--         "status":"OK",
--         "result":[
--             {
--                 "name":"Latte"
--                 "shops":{
--                     "name":["Boreal","StarBucks"],
--                     "price":["3.5","4.5"]
--                 },
--             }
--         ]
--     }
-- ]

-- desired result
-- [
--     {
--         "time":"369.625µs",
--         "status":"OK",
--         "result":[
--             {
--                 "name":"Latte"
--                 "shops":[
--                     { "name": "Boreal","price": 3.5 },
--                     { "name": "StarBucks","price": 4.5 }
--                 ],
--             }
--         ]
--     }
-- ]