Impossible to execute INSERT query with json data

[lizdeika]

Say we have tbl table with a data VARIANT column

json_string = '{"valid": "json"}'
query = "insert into tbl(data) select parse_json('#{json_string}')"
client.query(query)

This will lead to an error something like this:

SQL compilation error:\nInvalid expression [PARSE_JSON('{\"valid\":{\"json\"}')] in VALUES clause

Because of some type of escapement and added slashes to the query

[lizdeika]

https://github.com/rinsed-org/rb-snowflake-client/pull/32

Made a PR for this to be solved:

json_string = '{"valid": "json"}'
query = "insert into tbl(data) select parse_json(?)"
bindings = {
  "1": {
    "type": "TEXT",
    "value": json_string
  }
}
client.query(query, bindings: bindings)

[reidnimz]

@lizdeika appreciate the contribution. It's now available in version 1.1.0