Fetch and traverse

[anonimusprogramus]

Hi @tobiemh

In surrealdb, which one is better way of doing traverse?

SELECT *, ->bought.* AS items FROM user:1

or

SELECT *, ->bought AS items FROM user:1 FETCH bought

Thanks

ps. sample taken from youtube with this surrealql:

CREATE user:1 SET name='A', email='@a', age=1

CREATE item:1 SET name='Item One', price=10
CREATE item:2 SET name='Item Two', price=20

RELATE user:1->bought->item:1 SET price=5, created_at = time::now()
RELATE user:1->bought->item:2 SET price=10, created_at = time::now()

SELECT *, ->bought AS bought, math::sum(->bought.*.price) AS total, ->bought.*.out.* AS items FROM user:1 FETCH bought