Build BOM in Query

Are you trying to do it via SQL or as a BAQ?