Hello,
It is suggested not to query the Bonita database directly. The better approach is call Bonita REST API from your Grails application and you should be able to fetch most of the Case data that you may be looking for.
Bonitasoft empowers development teams with Bonita, the open-source and extensible platform to solve the most demanding process automation use cases. The Bonita platform accelerates delivery of complex applications with clear separation between capabilities for visual programming and for coding. Bonita integrates with existing solutions, orchestrates heterogeneous systems, and provides deep visibility into processes across the organization.