Include the following capabilities out-of-the-box with TDV.
Postgres 9.1 adapter - This allows for push-down to TDV catalog tables when converting Integer timestamp to actual timestamp.
TDV_HOME/conf/adapters/system/postgresql_9_1/postgresql_9_1_values.
<common:attribute xmlns:common="http://www.compositesw.com/services/system/util/common">
<common:name>/custom/TO_TIMESTAMP(~number)</common:name>
<common:type>STRING</common:type>
<common:value>TO_TIMESTAMP($1)</common:value>
<common:configID>TO_TIMESTAMP(~number)</common:configID>
</common:attribute>
SQL Server 2019 adapter - the attached file "microsoft_sql_server_2019_values.xml" contains common XML pushdown configurations for the following capabilities:
LTRIM, RTRIM, INSTR, GREATEST, LEAST, REVERSE, CONTAINS, NVARCHAR