How to fix couchbase update SQL with CTE causing an error?

I have a CTE based SUBQUERY block named sq_filter which returns this kind of JSON:

how to fix couchbase update sql with cte which is giving error?

I have CTE based SUBQUERY block named “sq_filter” which returns below kind of jsons

Is full join or outer join directly possible in Couchbase?

is full join or outer join in couchbase directly without doing any extra operations?

How to write sql++ query for updating nested json array in Couchbase?

I have below kind of Json document stored in CB collection