N1QL (Array All or [*]) in Analytics?


In N1QL to return all the cake in the products array is:
SELECT products[*].cake FROM bucket;

How do I do it in SQL++ ?

In Analytics it will be:

SELECT (SELECT VALUE cake FROM b.products ) AS cake
FROM bucket AS b

Alternatively you could use

SELECT ARRAY_STAR(products).cake FROM bucket