Generating table from SQL Query

Hello everyone.

I’m working on a code which would enable me to present results of SQL query as a Vaadin table. The requirements are that I have to be able to filter out the date and also I have to be able to load the query directly from XML config file.

The problem is that using SQLContainer to be able to filter out certain rows I cannot implement simple FreeformQuery and has to use FreeformStatementDelegate, which is much harder for generic implementation.

I would rather collect all the data from the generic query and then filter it out dynamically by hiding certain rows. Is there any simple way to do it with Vaadin?