RecSQL is a hack that allows one to load table-like data records into an in-memory sqlite  database for quick and dirty analysis via SQL. The SQLarray  class has additional SQL functions such as sqrt or histogram defined. SQL tables can always be returned as numpy record arrays so that data can be easily handled in other packages such as numpy or plotted via matplotlib. Selections produce new SQLarray  objects.