Using XQuery
<?xml version="1.0" encoding="UTF-8" ?> <scenario> <name>Using XQuery</name> <script>using_xquery</script> <sources> <source> <name>books</name> <extract> <sql> <![CDATA[ <titles> { for $x in doc(xml)/bookstore/book where $x/price>30 order by $x/title return $x/title } </titles> ]]> </sql> </extract> </source> </sources> <destinations> <destination> <name>books</name> </destination> </destinations> </scenario>