var result = await query
   .Include()
   .AsSplitQuery()       
   .ToListAsync(cancellationToken);

exec sp_executesql N'SELECT [i].[Id], [i].[NodeId]
FROM [Initiative] AS [i]

WHERE [i].[NodeId] IN (
    SELECT CAST([q].[value] AS hierarchyid) AS [value]
    FROM OPENJSON(@__qFiltered_1) AS [q]
)'

,N'@__qFiltered_1 nvarchar(4000)',@__qFiltered_1=N'["/3/1/1/"]'


exec sp_executesql N'SELECT [i].[Id], [i].[NodeId]
FROM [Initiative] AS [i]
INNER JOIN [InitiativeDimensionValue] AS [t] ON [i].[Id] = [t].[InitiativeId]

WHERE [i].[NodeId] IN (
    SELECT [q].[value]
    FROM OPENJSON(@__qFiltered_4) WITH ([value] hierarchyid ''$'') AS [q]         --> this is wrong
)'

,N'@__qFiltered_1 nvarchar(4000)',@__qFiltered_1=N'["/3/1/1/"]'