For the following SQL statement, if we prefer for the double quotes it prevents an escape for the inner foo string.
store.execute("INSERT INTO table (col1, col2) VALUES (1, 'foo')")
I've played around with the double-avoid-escape smart tag, but no combination seems to work, so unclear for me what should be used to handle this scenario and prevent the message.
C4001: Invalid string quote ", should be ' (invalid-string-quote)