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.
|