Re: Generating SQL statements in BL

[email protected] wrote:
> Use case: extending the getitems tag in DD, say for more versatile WHERE 
> clauses:
> 
> <xar:data-getitems......>
>   <where>
>     <property name="foo">27</property>
>   </where>
> </getitems>
> 
> Obviously the above is just an example (and a simplified one at that). 
> This basically comes out to generating SQL statements from XML. I'm 
> wondering whether there is anything out there that could be adopted, in 
> terms of XML schemas that represent SQL statements.
> I've been trolling around but haven't really found anything much. Since 
> this idea presumably is not new, can anyone point me to where I might 
> find something along these lines?
> 
> Thanks,
> Marc

Most of the work on XML + SQL seems to be dealing with totally different
matters than SQL query statements, so I would focus on plain XML parsing
here - if that's what you want to do :-)

Mike.