In addition to @tim.bradgate, As you are using map syntax this may be helpfull
FROM test AS d
WHERE d.orders.["0f17a3ac-addb-49e5-a687-b6124dfd371d"].destination = "AAA"
If you need to access the dynamic field you must use array brackets immediately
after dot (map access) i.e orders.[v] and v must be string or if it expression it must
evaluate to string. It evaluates expression inside array brackets, it must be string,
then converts into identifier and substitutes it and evaluate rest of the path.
ex: orders.["xyz"] ==> orders.`xyz` , orders.[f1] (f1 is "field1") ===> orders.`field1`