JSON_EXTRACT: doesn't use double quote path selector

[adi-eldar]

What happened?

Doesn't support extracting fields with dots in their name from json fields.
I have a JSON type column in my table which looks like that:
"normalized_fields": {"relation.parent.name": "name", "relation.parent.id": "id"}
I'm trying to extract relation.parent.name field in my query using:
select JSON_VALUE(normalized_fields, '$."relation.parent.name"') from table
When running this query using this image ghcr.io/goccy/bigquery-emulator:latest I get this error:
Error getting spec assets googleapi: Error 400: failed to scan rows: JSON_EXTRACT: doesn't use double quote path selector

What did you expect to happen?

To be able to extract fields with dots in their names from JSON columns (like in BigQuery SDK)

How can we reproduce it (as minimally and precisely as possible)?

Create a JSON column that contains a field with dots in its name, and try to extract this field's value

Anything else we need to know?

No response