I've got a few databases that use JSONB data types. I occasionally find it useful to bring these into a query layer.
Pro doesn't really know what to do with raw JSONB, and that's fine. I usually know what I'm looking for, and using the accessors "->" or "->>" work just fine.
However! When I attempt to do something else, such as using "jsonb ? 'key'" to check for the existence of a given key, Pro will not draw my layer, even though the attribute table populates correctly.
Can we please get Pro to play nice with built-in PostgreSQL functions? Or even just handle JSONB data in its raw state? (QGIS can do it 😘)
