If you’re handy python, check out its python api. Another method is to have gnucash store it’s data in a MySQL database, and query that directly. But I agree that having more powerful reporting built would be nice.