Compare two json values for equality

Question

(Note that this is using the Preview JSON feature in BigQuery.)

Is there a simple way to compare two json values to see if they're equal, ignoring key-ordering, recursively, for example:

{a: 1, b:2}    ===      {b:2, a:1}

As an example:

WITH tbl AS (
    SELECT JSON '{"a": 1, "b": 2}' as a, JSON '{"b": 2, "a": 1}' as b
) SELECT a,b, a=b?? FROM tbl

user_5221944 · Answer

Try below

SELECT a,b, TO_JSON_STRING(a) = TO_JSON_STRING(b) 
FROM tbl

with result