JSON_Table got a deep dive in the context of the Document DB functionality.  @Stefan Wittmann presented an excellent session about this at last year's Global Summit

https://www.youtube.com/embed/T7RzkugC7QQ
[This is an embedded link, but you cannot view embedded content directly on the site because you have declined the cookies necessary to access it. To view embedded content, you would need to accept all cookies in your Cookies Settings]