Is it possible to give us a sample query to model our custom queries against?
Unfortunately custom reports have very limited SQL coverage at the moment so there is no documentation yet for this. What are you trying to achieve? Or just to play around?
A post was split to a new topic: Inventory items by location report