I have SQL query which constructs the JSON in the SELECT clause. After reading the query in JSON, string format is used to substitute the values. Because of the curly braces, string format(.format()
) is not working. I can t use {{
to escape the curly braces, because of the way existing logic is constructed. Is there any other to escape curly braces in the query/string?
Example string : query = SELECT {"Success":true, "Message":"ErrorCode"}, col1, col2 FROM Table1
Usually we don t get this JSON in query. This is an exceptional case. That s why didn t used any JSON specific way and I don t want to change the existing notebook