JSON data with \u0000 errors in Postgres with "unsupported Unicode escape sequence"

[e-gineer]

Describe the bug

Running this query

select * from shodan_search where query = 'ssh -port:22'

Seems to return some JSON data with \u0000, leading to the error:

Error: unsupported Unicode escape sequence

Steampipe version (steampipe -v)
Example: v0.2.5

To reproduce

> select * from shodan_search where query = 'ssh -port:22'
Error: unsupported Unicode escape sequence

Expected behavior

I'd expect the JSON column handler to either strip the null field \u0000 out to fix the parsing, or to replace the JSON with error content.

Additional context

N/A