the real data is interspersed throughout a gigantic text file, and normalizing it for a database isn't really an option.

I'm sure you're right. But look at my example again. No file or external database is created and no normalizing is done at all. It just takes the same $arrayref you started with and creates a temporary-in-memory table and allows you to query the $arrayfef as if it were a database.