Add an ability to format info date and insert date expression into JDBC SQL queries

[yruslan]

Background

Users want to customize SQL queries with information date based dates as part of an expression, including table names. For example:

SELECT * FROM my_table_202402

where 202402 is yyyyMM part of the information date.

Feature

Add an ability to format info date and insert date expression into JDBC SQL queries .

Example

input.sql = "SELECT * FROM my_table_${formatDate(beginOfMonth(@infoDate), 'yyyyMM)'}"

Proposed Solution

1. Introduce formatDate() that can be used like this: formatDate(@infoDate, 'yyyyMM)' => 202402
2. Allow date expressions in SQL queries, for example using ${} escaping (see the example above).