There’s a lot of support for JSON in Dremio without resorting to UDFs. For example, you can use . to access children, and the FLATTEN() operator to handle arrays:
https://docs.dremio.com/sql-reference/sql-functions/nested-data.html
What is particular are you trying to do with JSON?