Support json functions?

[danielsaaf]

Hi.

I'm not sure if this should be posted as an issue or not. (If not, feel free to remove it! )

The issue I got is that I have some data, in the bigquery table I would like to query which is stored as json-objects.
When writing pure SQL I'm using the json functions (json_value/json_query) and json_value_array/json_query_array to be able to query the data inside the json object.

I have been trying different ways of doing this in ibis without any success and haven't found any examples online.
Based on that, am I now rising this issue as both a question if it's doable? (if it is, I would appreciate I I can get some type of guideline on how to proceed? I know that this isn't a help forum - but hopefully I can contribute with some documentation to help others in my situation.)

If it's not supported, I would like to raise this as a request! (Don't think my skills are enough to contribute with such a feature - but I would like to contribute in someway if it's possible. )

[tswast]

These seem reasonable to add. It would be possible to add these in this dialect and monkeypatch in as is done here: https://github.com/GoogleCloudPlatform/professional-services-data-validator/blob/develop/third_party/ibis/ibis_addon/operations.py

My preference is to add any new methods / operators to https://github.com/ibis-project/ibis first, though.

Would you mind opening up a feature request at https://github.com/ibis-project/ibis along with the proposed syntax? Any thoughts on how this might work in non-BigQuery backends would also be appreciated.