I need a query tool that will allow my endusers to select data from several tables and produce a data set that I send to a queue in my custom app.

My custom app is a multi-client app.

One requirement is that I need to be able to query tables with the same name across multiple database containers.

For instance, I have two clients. Each client has its own set of tables in its own database container in its own folder.

If I want to see all the active employees for both clients, I need to be able to query the employee table in each database container for both clients.

Another requirement is that the query tool needs to be compatible with the Codemine Framework.

Any recommendations?

Thanks.
Regards,
Deb