If somebody is interested in connection to various JDBC-compatible databases through postgres_fdw, please look at my pq2jdbc project: https://github.com/postgrespro/pq2jdbc Details of the project are in README file.
If somebody can find some other use cases for libpq to JDBC adapter, please let me know!