EXTRACT transform function support was added in #9184, but there is no scalar function version of it which causes it not usable for literal evaluation or intermediate stage in multi-stage engine.

For context, calcite automatically re-write YEAR, QUARTER, MONTH etc. into EXTRACT in multi-stage engine, thus it is critical to support EXTRACT