mysql_fdw does not work with Pushdown in Tembo

[aymanapatel]

I was trying to use mysql_fdw for moving data between a Postgres and a MySQL instances (Both are in different machines) and getting the error:

Query 1 ERROR at Line 1: : ERROR:  could not open "/var/lib/postgresql/data/tembo/extension/mysql_fdw_pushdown.config": No such file or directory

Reproducing steps

1. Created warehouse table in MySQL

2. Created the FDW in Postgres with mysql_fdw

CREATE SERVER mysql_server
         FOREIGN DATA WRAPPER mysql_fdw
         OPTIONS (host '<my-host>', port '<port-number>');

-- create user mapping
CREATE USER MAPPING FOR postgres
    SERVER mysql_server OPTIONS (username '<username>', password '<password>');

-- create foreign table
CREATE FOREIGN TABLE warehouse
(
 warehouse_id      INT,
 warehouse_name    TEXT,
 warehouse_created TIMESTAMP
)
SERVER mysql_server
         OPTIONS (dbname 'defaultdb', table_name 'warehouse');      
         
 SELECT * FROM warehouse ORDER BY 1;

Error:

Query 1 ERROR at Line 1: : ERROR:  could not open "/var/lib/postgresql/data/tembo/extension/mysql_fdw_pushdown.config": No such file or directory

So the Pushdown from MySQL -> Postgres does not work. But inserting data into Postgres is reflected on MySQL instance.
I am assuming that the mysql_fdw_pushdown is in recent versions and Tembo is using the version which does not have this feature.