SQL 2005 supports the querying of XML data (either typed or untyped), so this would translate to SELECT * FROM Customers WHERE AddressXML.value('(/Address/Town)[1]', 'nvarchar(1000)') = 'London'
The agimatec tools contain some utilities to enable generation of files, source code etc. from sql files and annotated java classes. The agimatec-dbmigrate tool is a database migration/script execution framework that can execute sql scripts, groovy scrip