Is there a way to get the full path of the key when querying Azure Cosmos DB?

Question

If you execute a SQL query to Cosmos DB where the following JSON is registered, the nest key will be omitted.

Is there a way to get the full path of the key when querying Azure Cosmos DB?

• JSON DATA json
  {
  "id": "001",
  "nest":
  {
  "name": "Tom",
  "age": 45
  }
  }
  • Query Result
  SELECT c.id, c.nest.name FROM c {
  "id": "001",
  "name": "Tom"
  }

  ---

• Query result I'm expecting SELECT c.id, c.nest.name FROM c {
  "id": "001",
  "nest":
  {
  "name": "Tom"
  }

  }

Answer 1

I think this does the trick:

SELECT c.id, { "name": c.nest.name } AS nest FROM c