Cannot dump JSON object with Null values to string about spyql HOT 2 CLOSED

Gah, great solution -- that did the trick! Thanks for the quick workaround.

from spyql.

Thank you @mgburns for your feedback and for reaching out!

This use case is not supported... but makes sense supporting it (e.g. by adding a dump_json helper function).
Right now, you can do the following workaround:

$ spyql 'IMPORT json AS js SELECT js.dumps(.a, default=lambda x: None if x is null else str(x)) AS a FROM {"a": {"foo": 1, "bar": null}} TO sql(table="mytable")'

INSERT INTO "mytable"("a") VALUES ('{"foo": 1, "bar": null}');

Please let me know if it solves your issue.
Thanks!

from spyql.