Input and Output Model

ChronusQL reads JSON objects. The tests cover JSON Lines and JSON arrays.

JSON Lines input:

{"value":1}
{"value":2}

JSON array input:

[
  {"value":1},
  {"value":2}
]

Both forms produce two events.

Output is JSON Lines. Projection preserves nested JSON structure unless an alias flattens or redirects the output path.

SELECT field1.field2.field3 INTO output FROM input

Tested input:

{"field1":{"field2":{"field3":42}}}

Tested output:

{"field1":{"field2":{"field3":42}}}

Missing fields project as `null`:

SELECT value, missing INTO output FROM input

Tested input:

{"value":9}

Tested output behavior:

{"value":9,"missing":null}

If an intermediate nested object is missing, null, a string, or a number, ChronusQL returns `null` for the requested nested field rather than throwing.