{
  "email": "joan.smith@somedomain.com",
  "name": {
    "first": "Joan",
    "last": "Smith"
  }
}

SELECT *
FROM c
WHERE c.name.first + " " + c.name.last = "Joan Smith"

SELECT *
FROM c
WHERE c.name.first + " " + c.name.last
  IN ("Joan Smith", "Juan Suarez")