Connection based on custom query?

[nlpx]

Hi,

I stumbled across https://discuss.airbyte.io/t/running-custom-sql-query-in-airbyte-for-postgresql/5487 whilst facing the challenge of trying to partially replicate data from a postgres source.

Is there any way to query a table and only replicate the result to the destination?

Thank you for any hint.