Struct JsonbEachTableFunction 

pub struct JsonbEachTableFunction {}

A DataFusion TableFunctionImpl that expands a JSONB object or array into rows of (key, value).

For objects, key is the field name. For arrays, key is the element index (as a string).

Usage:

SELECT key, jsonb_as_string(value)
FROM jsonb_each(
  (SELECT properties FROM processes WHERE process_id = '...')
)

Implementations

impl JsonbEachTableFunction

pub fn new() -> JsonbEachTableFunction

Trait Implementations

impl Debug for JsonbEachTableFunction

fn fmt(&self, f: &mut Formatter<'_>) -> Result<(), Error>

Formats the value using the given formatter.

impl Default for JsonbEachTableFunction

fn default() -> JsonbEachTableFunction

Returns the “default value” for a type.

impl TableFunctionImpl for JsonbEachTableFunction

fn call(&self, args: &[Expr]) -> Result<Arc<dyn TableProvider>, DataFusionError>

Create a table provider