Hi all, we use Postgres a lot and make heavy use of the JSONB datatype [1]. Is there support for something similar in Calcite? If so, can someone point me to the docs as I’ve not found anything in the list of builtin functions.
There are several reasons why it would be cool for us to have Calcite in Front of postgres to do some query rewriting if necessary but for that we would definitely need support for something which could be transformed to JSONB. Best Julian [1] https://www.postgresql.org/docs/9.5/functions-json.html