Search Shortcut cmd + k | ctrl + k
jsonata

The JSONata extension for DuckDB enables expressive, JSON-focused querying and transformation directly within SQL using the powerful JSONata expression language.

Maintainer(s): rustyconover

Installing and Loading

INSTALL jsonata FROM community;
LOAD jsonata;

About jsonata

For more information regarding usage, see the documentation.

Added Functions

function_name function_type description comment examples
jsonata scalar NULL NULL NULL
jsonata scalar NULL NULL NULL

Overloaded Functions

| function_name | function_type | description | comment | examples | |—————|—————|————-|———|———-|

Added Types

| type_name | type_size | logical_type | type_category | internal | |———–|———-:|————–|—————|———-|

Added Settings

| name | description | input_type | scope | aliases | |——|————-|————|——-|———|