Airbyte source and destinations are independent between them. This gives more flexibility because you can choose any source and any destination to sync and always work. Also, some cases from the transactional database (your postgres) you have json data you want to transform to a more analytical model to your datawarehouse.
But, maybe to bring more performance for some specific cases having this option could be great. Could you open a Github issue to discuss there?