Allow wide_number_mode parsing of JSON data

[anor4k]

Environment details

• Programming language: Python
• OS: macOS
• Language runtime version: 3.12
• Package version: 1.14.0

Steps to reproduce

1. Try to insert a dict in a JSON type column with some specific float values, e.g. 13.7391432
2. Spanner raises an error

Apparently this is expected per the spanner specification, but can be worked around by using PARSE_JSON(..., wide_number_mode=>'round'). Would love to be able to always round these when inserting by passing a config to the SQLAlchemy column.

[olavloite]

@anor4k Thanks for reaching out. I don't see a way that we automatically call this function in the Spanner SQLAlchemy dialect for all columns with type JSON, but it is possible to call this function explicitly from application code when inserting/updating a row. See https://github.com/googleapis/python-spanner-sqlalchemy/blob/main/samples/parse_json_sample.py for an example for how to do that.