cannot parse/access json response of query: Bad escaped character about mosaic HOT 3 CLOSED

Thanks! I tested this and the problem is that the return value of the query is already parsed. Instead of calling JSON.parse, simply use the returned q array.

If using a DuckDB server (socket connector), the result will be sent back as a JSON string and parsed internally. Meanwhile, DuckDB-WASM (wasm connector) only produces Arrow tables, so when json is requested the Arrow table is coerced to a JS-Array-of-Objects compatible array.

from mosaic.

Thanks for reporting the issue. Can you share a basic table CREATE and/or INSERT query with data that replicates the issue? (A single row table should be fine!) Then we can test directly on our end and see where in the pipeline the bug may arise.

from mosaic.

here you go:

vg.coordinator().exec('CREATE TABLE test AS SELECT \'^(?P<DD>0[1-9]|[1-2]\\d|3[0-1])/\' as teststring' );
vg.coordinator().query("SELECT teststring from test;", {type: "json", cache: false})
    .then((q) => {
            console.log(q.toString());
	    const t = JSON.parse(q);
            console.log(t);
	});

results in:

{"teststring": "^(?P<DD>0[1-9]|[1-2]\d|3[0-1])/"}
VM262:1 Uncaught (in promise) SyntaxError: Bad escaped character in JSON at position 37
    at JSON.parse (<anonymous>)
    at index.html:57:19
```

from mosaic.