Post Thread

Saqib Ali @gql

Can #SQL Understand JSON? JSON_EXTRACT in Exasol can return multiple fields from the same JSON string in one call, each mapped to a typed output column through an EMITS clause:

SELECT id,
       e.order_id,
       e.customer
FROM order_events,
     JSON_EXTRACT(json, '$.order_id', '$.customer')
       EMITS (order_id INT, customer VARCHAR(100)) e;

www.exasol.com

Can SQL Understand JSON?

Learn how to query JSON with SQL in Exasol using JSON_VALUE and JSON_EXTRACT, then use extracted values alongside relational data.

1h ago (1:20 PM · Sep 12, 2026)

0 Replies

0 Reposts