Yes Checkout https://developer.couchbase.com/documentation/server/5.0/n1ql/n1ql-language-reference/select-syntax.html
Examples at https://developer.couchbase.com/documentation/server/5.0/n1ql/n1ql-language-reference/selectintro.html
If you need to sort the array or limit array elements use subquery expression you can find documentation . Also checkout Multiple join from different bucket