To return the first item of an array
You can access the first entry of an array with this function. This function comes in handy if you try to access a record in an array of records.
If you combine the function with
selectand the respective array has more than 1 element, we recommend sorting the array first with
first(["B", "A", "C"])
Result: Returns the first record of the Customer table.
first((select Customer where substr('Last name', 0, 1) = "A") order by 'Last name')
Result: Returns the first record of the table Customer where the last name starts with an A.