The JSONata extension, developed by Query.Farm, brings the power of JSONata query and transformation language directly to your SQL queries in DuckDB. Transform, query, and manipulate JSON data with sophisticated expressions—all without leaving your database environment.
Full documentation, including installation, usage, the function reference, and cookbook examples, is available at:
https://query.farm/products/extensions/jsonata
INSTALL jsonata FROM community;
LOAD jsonata;