% string duplication prevents using PARSE_DATE() SQL function

[strunov]

Describe the bug

If I use a SQL data asset or a SQL unexpected rows expectation using % format then the query gets changed - the % gets duplicated.

Escaping the query with \% produces \%% query string.

To Reproduce Please include your great_expectations.yml config, the code you’re executing that causes the issue, and the full stack trace of any error(s).

• I'm using an ephemeral context
• there is no runtime error
• the error is at database engine level
• query gets mangled

Expected behavior Raw queries should be treated as is IMO

Environment (please complete the following information):

• Operating System: windows
• Great Expectations Version: 1.0.2
• Data Source: BigQuery
• Cloud environment: local

Additional context Add any other context about the problem here.

[adeola-ak]

hi @strunov, thanks for bringing this to our attention. I've shared it with the team and will follow up soon!

[cdkini]

@strunov could you please provide an example of a query that happens to cause this issue? Additionally, where is it that you're actually seeing the mangled query? In the result?