exasol-json-tables

Use when working on the query surface of Exasol JSON Tables in this repository. Covers wrapper views, helper schema generation, SQL preprocessor behavior, `TO_JSON(...)`, JSON helper semantics, path and array syntax, and validation of user-facing JSON-friendly SQL on the wrapper surface.

Use when implementing, debugging, or extending Exasol SQL preprocessors to customize SQL syntax, add compatibility layers, enforce query governance, build wrapper-view plus preprocessor architectures, or bridge user-facing SQL into other Exasol extension points such as virtual schemas. Covers official Exasol preprocessor APIs, upstream GitHub examples, Lua-first implementation patterns, architecture tradeoffs, and live-validation workflow.

Use when migrating MongoDB query or aggregation workloads into the Exasol wrapper-view plus preprocessor architecture in this repository. Covers MQL-to-SQL translation patterns, analytics-focused migration strategy, known wrapper strengths and limits, official MongoDB source patterns, and Nano validation workflow for ported workloads.

Use when working on the reshape stage of Exasol JSON Tables in this repository. Covers structured results, nested output materialization, structured_shape and synthesized_family authoring, durable or in-session result families, `TO_JSON(...)` as the primary final outlet, and turning relational query output back into the Exasol JSON Tables nested contract.

Use when working on the ingest stage of Exasol JSON Tables in this repository. Covers JSON or NDJSON ingestion into the source table-family contract, source-manifest generation, Exasol import flow, Rust ingest crate usage, and validation of ingest artifacts before wrapper generation.