Need more information for the query you need extract fo B1 DB.
Propose one meeting, with the requirements, and your time lapse.
I have meny years work with SAP B1, querys, layouts, Format Search, AddOns, Integrations, and another software usefull to your environment.
regards