This is a real pain typically. But, Bubble has an API connector that can query data in and out a third party data source (in my case its a Postgres that I acce

This is a real pain typically. But, Bubble has an API connector that can query data in and out a third party data source (in my case its a Postgres that I access over REST calls). Bubble's data layer is terribly slow. I'd recommend maintaining the bulk of your data in an efficient self-hosted or managed instance