Return Object vs a Array with 1 Object

SQL++
1

I am trying to find a approach that will me allow to only return a Object as i know it is only one record since i am using a key but i don’t have much luck. Below is the query that curently returns an Array with a single object as it uses the KEYS ad that’s unique

SELECT c.type,
       item.*
FROM Contacts c USE KEYS 'lookup::3944A895-3B01-4525-A332-0CCD90C62D40'[0]
UNNEST c.data AS item
WHERE item.id = "Last Name"
2

N1QL query results always gives array. You need to take care of that in the SDKs iterate over array.