How to define a raw sql in the datamap.xml file and use it through SQLTemplate

[Kumar]

Hey,

I have defined few queries in the datamap.xml file and and accessing it
using MappedSelect.query("queryName")

My quick question is, I want to define a native sql query in the
datamap.xml file and to access in the code. Currently MappedSelect.query()
is returning a MappedSelect which i cannot use with SQLTemplate.

Thanks in Advance
Saravana Kumar.M