SQL operation against a cached result set

[Zenikko Sugiarto]

Hi all,

I would illustrate what I am trying to do with an informal pseudo-code

ResultSet rs = db.query("select * from blah");

FooStructure fs = new FooStructure("foobar",rs);
ResultSet rs2 = fs.query("select distinct column1 from foobar where column2='meh'");

In other words: is there such a class that does what FooStructure is doing? holding the content of a ResultSet in a structure that we can apply normal SQL operations against?

I know that some people would say, well why don't you put the select distinct column1 in the initial query in the first place. THIS IS NOT THE POINT (pardon the caps). The point is, I am looking for a SQL-aware data structure that is ResultSet-friendly... (before I go and reinvent one..)

... anyone?

[Scott Selikoff]

Have you looked at ibatis?