make json ds support nested path query

[gaecoli]

What type of PR is this?

• [ ] Refactor
• [x ] Feature
• [ ] Bug Fix
• [ ] New Query Runner (Data Source)
• [ ] New Alert Destination
• [ ] Other

Description

How is this tested?

• [ x] Unit tests (pytest, jest)
• [ ] E2E Tests (Cypress)
• [ ] Manually
• [ ] N/A

Related Tickets & Documents

Mobile & Desktop Screenshots/Recordings (if there are UI changes)

[gaecoli]

There is no rush to merge this branch. We should listen to users’ suggestions and provide guidance to satisfy users.

https://github.com/getredash/redash/discussions/6938

[SmallStrayFox]

compiled pr as docker image and tested and can now traverse nested json, e.g. as per original comment #6938 with example json, can now for instance set path: data.0.awarded.0 to access the awarded array, however it currently only returns 1 record, e.g. if calling api would usually return 100 awarded array objects then i'd expect setting the path as above to return them all when i run the query in redash.