Can Arrays be treated as DB tables?

[steve souza]

Does anyone know of an open source API/class that allows you to query arrays (Object[][]) in much the same way you would query an sql table? Or even an API that doesn't use select syntax, but returns the same result. This code could return a subset of rows, or columns.
For example:

 
Object [][] arrInput={            
     {"John", "A", "Doe"}, 
     {"John", "B", "Smith"},
     {"Joe", "D", "Jones"},
     {"Ray", "F", "Jones"},
     {"Mark", "A", "Jones"}};
Object[][] arrOutput=SQLArray.select("select col1, col3 from array where col3 = 'Jones'", arrInput);
/*  arrOutput would have the following:
           { {"Joe",  "Jones"},
             {"Ray",  "Jones"},
             {"Mark", "Jones"}};
*/