Function arrayFirst, arrayFirstIndex, arrayLast and arrayLastIndex will

Why it matters

Previously, these functions did not support Nullable filter results, which caused incorrect behavior when filters contained NULL values. This update ensures that NULL results are properly excluded, improving the accuracy and reliability of array element selection based on filter criteria.

How to use it

Users can simply continue to use the functions arrayFirst, arrayFirstIndex, arrayLast, and arrayLastIndex with Nullable filter expressions. The functions will automatically exclude NULL values from the filter results without requiring any changes to the existing query syntax.