JDBC Native fails on variable not found when @infoDate is used as part of a function

[yruslan]

Describe the bug

JDBC Native SQL queries allow specifying arbitrary expressions, like an example below. But an error occurs when used this way:

za.co.absa.pramen.core.expr.exceptions.SyntaxErrorException: Unset variable 'infoDate' used.
  at za.co.absa.pramen.core.expr.parser.DateExpressionEvaluator.addVariable(DateExpressionEvaluator.scala:48)
  at za.co.absa.pramen.core.expr.parser.Parser.$anonfun$parse$1(Parser.scala:105)

Code and/or configuration snippet that caused the issue

input.sql =

SELECT * FROM my_table WHERE date_col='@{yearMonthOf(plusMonths(@infoDate, 1))}-16'

Expected behavior

Pramen should return a valid date and not throw an exception in this situation.

Context

• Pramen/pramen-py version: 1.8.9
• Spark version:
• Scala/Python version:
• Operating system: