Yeah, there are inherent limitations with a no-code platform. No table joins and you can only get 100 records at a time using the REST API. I've developed some complicated Node Red flows to iterate though records.