Restlets are probably your best bet. Another avenue is SOAP web services, which has bulk list operations. But that will be deprecated with update 2026.1

As far as what you call hydration, suite analytics connect and the relevant connect drivers are the way I would go. Same SuiteQL syntax, but better for large volumes of data.