But XML::XQL (and friends) should be a good starting point for you.

Michael

Thanks -- just what I needed to get going the right direction! New to perl, much appreciation.

I wouldn't use XML::XQL though. It is a rather old module, but most of all it is based on a query language that never became a standard. There is really no point in learning XQL nowadays. You would be much better of learning XPath, either using XML::XPath or (probably a better idea) XML::LibXML.

The reason you have seen SQL to XML on CPAN is because it is quite easy to define an XML structure that will hold the result of an SQL query. Relational tables have a well defined structure, and the XML just mirrors it. So you can take any SQL query and dump it as XML using a DTD defined by the module.

Now doing the opposite is quite different. You have to take an XML document with an unknown structure, and map it to one, or more, row, or maybe table. There is no hard and fast rule here.

So you will have to write code for this.

Hopefully the code is not necessarily very complex. Look at Ways to Rome 2 - Kourallinen Dollareita for examples of how to do a very similar task, using various modules.