Can't escape in Query JSON with SQL

Queries and Resources
1

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 {{getHoge.data}} t1, {{getFuga.data}} t2 WHERE t1.columnA like CONCAT(t2.columnB, '\_%')

2

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 https://www.databasestar.com/sql-escape-single-quote/