Hi,
Just a quick update to mention that since CrateDB added support for DECLARE CURSOR this is now working but there are currently some limitations depending on the queries and the version of PostgreSQL, see CrateDB/postgres_fdw/LIMIT parameter for details.