In that sense, generated query makes sense to me: accountMetadata is null, when holder is null. Even if this is intended, the output of the query is an empty array, even though I have verified that it ...

The query result is still the same but the filter is not longer being folded back to SQL Server. Instead all the data is being returned to Power Query and the filter is taking place there.