It really looks like this is a bolt-on that was not tested properly. Wix would be so much more powerful if it had an ODBC interface to SQL Server - or any other external database. The Collections are really unsophisticated, joining them in queries has to be done in complex code.