Hey all- for a new search tool I'm writing, I'm thinking it might be 
prudent to use XML transformations to convert between some various query 
formats.  Is anyone out there aware of an XML schema that could represent 
a SQL select statement?

You know, something like this

<select>
 	<what-list>
 		<what-element>a.*</what-element>
 	<from-list>
 		<from-element>
 			<table>asset</table>
 			<alias>a</alias>
 		</from-element>
 	</from-list>
 	<where-list>
 		<where-element>a.asset_id = 500</where-element>
 	</where-list>
</select>

But with support for hierarchical queries, joins, and other nasty 
business.

Thanks much!

Rafe Rosen
Software Developer / System Administrator
Macaulay Library
Cornell Lab of Ornithology
Ithaca, NY
(607) 254 2132
[log in to unmask]