Spec Deviation in sql:ParameterizedQuery and sql:ParameterizedCallQuery

[niveathika]

Description:

As per the spec, RawTemplate should support Backtick(`) within the Query. This can be supported by introducing the following interpolation, ${"`"}.

Currently sql:ParameterizedQuery and sql:ParameterizedCallQuery does not support ${"`"} intropolation.

[niveathika]

Reopening as the fix is incomplete, this will fail for following scenario,

Payment[] paymentArr = [{date: "2022-02-03", amount: 0.0, employee_id: 0, reason: "`"}];
    sql:ParameterizedQuery[] insertQuaries = from var payment in paymentArr
        select `INSERT INTO Payment(date, amount, employee_id, reason) VALUES(${payment.date}, ${payment.amount}, ${payment.employee_id}, ${payment.reason})`;

With the fix the ``` used in the user insertion data is not escaped and leads to query corruption.