Many dialect-specific functions can be rewritten in Feldera using combinations of existing SQL functions.
We should build and maintain a compatibility library for per SQL dialect.
For example, a SQL library could have definitions like

CREATE FUNCTION CURRENT_DATE() RETURNS DATE NOT NULL AS CAST(NOW() AS DATE);