Require Alternative approach instead of BIP

We are using the below BIP query to extract and correlate data from various financial and customer management tables combined to get comprehensive transaction details. This includes data for transaction batches, customer transactions, receipt methods, and payment schedules to ensure accurate financial reporting and analysis. Need an understanding of whether we have any easier way of implementing this with APIs, if not then a confirmation that we are on the right track in using this query.