Getting Nested query result from Cosmos DB with property named "Value"
If property name is the same as reserved word (in this case Value),
following syntax could be used:

["Value"]


In the case above here is working query:

SELECT ed 
FROM c 
JOIN ed IN c.ExtendedData 
WHERE ed.Key = "MembershipTypeId" 
AND ed["Value"] = "224"