Can't escape in Query JSON with SQL

How can I escape _ within WHERE clause in Query JSON with SQL.
Data-set is like this below
[{"columnA":"test_123"},{"columnA":"test_124"},{"columnA":"test_125"}] [{"columnB":"test"}]
I tried this and result was no matched.
SELECT t1.columnA, t2.columnB FROM {{}} t1, {{}} t2 WHERE t1.columnA like CONCAT(t2.columnB, '\_%')

I think what you need to do is use the ESCAPE keyword (there’s a pretty good description of how to use it in the “Escaping SQL Wildard Characters” section of this post