one can (for instance, in postgres) use the SQL-machinery against a so-called foreign table,

Fair enough! That would be especially convenient if the database offers some aggregation functions to perform the logic of the Perl code, so that you wouldn't even need to SELECT all the stuff back. That's beyond my postgres-fu, though.