pgx-managed Postgres w/ wrappers behaved differently from locally-installed Postgres w/ wrappers

Hello, I'm trying to use the clickhouse_fdw wrapper and am hitting a snag. With correlated sub-query queries, I get an error and a different plan with wrappers installed into my local PostgreSQL. It works without error with wrappers installed in a pgx-managed PostgreSQL. Let me explain. I have Clickhouse running locally, with related tables account and order and views on those tables. I have PostgreSQL scripts that set up a foreign server from PostgreSQL to Clickhouse running locally, and foreign tables set up on the views for the account and order table. The views are involved to work around the clickhouse_fdw not yet supporting UUID fields, but don't dwell on that fact. I'm pretty sure that's unimportant and focusing on it would be a red herring. Anyway, the query I'm trying to run in PostgreSQL against the foreign tables looks like this. It's a simple query with a sub-query in the where clause to pick out a random account entry …