If the input JSON has an array object the output path does not contain any array items. So if somebody is looking to see what is in the array it is not possible.
That limit the functionality and would be great if it was possible to see the path to the array and all elements inside, especially because the JSONtext path notation allows for it :)
To first support this, we need to be able to Insert at the end of an array, which requires Path notation for this. Following SQLite JSON1 in using $[#] to indicate end.
https://www.sqlite.org/json1.html#jins