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

Analytics
1 
{
"products":[
            {"water":true,"cake":"all"},
            {"water":false,"cake":"some"}
           ]
}

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

How do I do it in SQL++ ?

4

In Analytics it will be:

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

5

Alternatively you could use

SELECT ARRAY_STAR(products).cake FROM bucket