Need N1ql query to Unnest array object inside array object?

SQL++
2

SELECT ud.doc.product FROM default d UNNEST d.info AS ud;

You can also add predicate

SELECT ud.doc.product FROM default d UNNEST d.info AS ud WHERE ud.id = "prod::CC+000+L1";

Checkout Nesting and Unnesting by @johan_larson http://blog.couchbase.com/wp-content/uploads/2017/03/N1QL-A-Practical-Guide-v2.pdf