And so there is! Well, to extend on this...
How about allowing users to define their own RSS file based on the sections they choose. For example, I may be interested in Snippets and SoPW, so I can choose to see new nodes in these sections. Then, a custom RSS could be created for me to use. There would be a few ways to get this done, text files, or maybe generated dynamically by a CGI script. Just an extended thought..
As long as enough information is provided in the RSS, the DBD::RAM module can be used to fetch the data and then provide a DBI query against it (full SQL!) in short order.