You can pass arbitrary SQL to the method Table.executeQuery(DbSchema schema, String sql, Object[] parameters, Class<K> clss). This will generate an object from each row in the resultset.

Note: for custom binding you can use BeanObjectFactory.Registry.register() to register a factory for your class (e.g. if column names don't match field names)