xml-dev - Embedding SQL statements in XML

[Michel Rodriguez <mrodrigu@ieee.org>]

Hi,

I was wondering whether some work, maybe standardization work, has been
done on embedding data from a relational database into an XML document.
The document is processed to generate the complete XML document, but the
non-processed version is the one that is edited and managed in the system.

I have found no trace of public work on that topic, although I know of a
couple of old SGML implementations.

I realize that various type of results can be required, from a single
value to a complete table, through one or more rows or columns (columns
being even trickier than rows). Plus the queries can be variously
parametrized and connection to the DB is always a problem. But I am
surprized not to find _anything_ on the subject.

I am looking at something like standard fragments looking like 

<p> text <sql_value db="db1" query="select price from book where
isbn=123456"> more text</p>

for single values and like

<tr><sql_row db="db2" query="select title, price from book where
isbn=123456"></tr>

for rows

Would anyone know of anything in this area?

Thank you

Michel Rodriguez
Perl & XML