Support for pushing down datetime query

[zhiyuan192shine]

Search before asking

• I had searched in the issues and found no similar issues.

Description

version：flink-doris-connector-1.16-24.1.0

desc：
When the Doris table contains a large volume of data, loading substantial amounts of data can be exceptionally slow and require a significant amount of memory. It is desirable to support the pushdown of time functions.
For example, vtime >= DATE_FORMAT(TIMESTAMPADD(DAY , -7, NOW()), 'yyyy-MM-dd')

Use case

CREATE VIEW v_tmall_user_behavior AS
SELECT item_id,
user_id,
action,
vtime
FROM ods_tmall_user_behavior
WHERE vtime >= DATE_FORMAT(TIMESTAMPADD(DAY , -7, NOW()), 'yyyy-MM-dd')
AND action = 'alipay'
;

Related issues

No response

Are you willing to submit PR?

• Yes I am willing to submit a PR!

Code of Conduct

• I agree to follow this project's Code of Conduct