Sometimes the best features start with a simple question: how far can we push this?
That’s exactly where Exasol JSON Tables began; as a deep-dive experiment to see whether Exasol could make JSON feel like a true first-class citizen, without touching core. The answer, it turns out, is a resounding yes. And today we’re tagging the first formal release: Exasol JSON Tables v0.1.
The query interface was reshaped to feel 100% JSON native, with full support for arrays, objects, and variants, all while keeping SQL’s full expressiveness and power intact. You don’t have to choose between JSON ergonomics and relational muscle. You get both.
What It Can Do
Exasol JSON Tables now supports a genuinely JSON-native workflow, end to end:
-
Ingest JSON and NDJSON into a stable relational contract
-
Query nested data using path syntax, array iteration, and JSON-aware helpers
-
Reshape results back into nested output with
TO_JSON(...)
This Is Just v0.1, an early release and very much a living project. The foundation is solid, but there’s plenty of room to grow and your feedback will shape where it goes next.
Explore the project: https://github.com/exasol-labs/exasol-json-tables
We’d love to hear what you build with it!
