Like in MS Access queries with all the functionality to combine GDB tables\feature classes, add craeteria to filter subsets, Group By, Calculated field (base on other fields), ect.
Not static like it is now in 'make table query' tool (Arctoolbox), but dynamic (respond to origin tables cahnges).