tsql - SharePoint CAML Query to T-SQL -

i hoping convert caml query t-sql. sharepoint site, have data warehouse (sql server 2005) hosts same data (it populated through splist eventreceivers: itemadded, itemupdated).

i involved in task handle growth of lists , speed of custom webparts display list data. hoping instead display our list contents using data warehouse , going remove items splists workflow has been completed.

currently, user of custom webpart displays splist contents allowed select spview display content in way (i.e. filtering, sorting , showing necessary columns). keep functionality , hoping take view's caml query , convert t-sql query against data warehouse.

e.g.

<query>   <where>     <or>       <eq>         <fieldref name="contenttype" />         <value type="text">my content type</value>       </eq>       <isnotnull>         <fieldref name="description" />       </isnotnull>     </or>   </where>   <order>     <fieldref name="author" />     <fieldref name="authoringdate" />     <fieldref name="assignedto" ascending="true" />   </order>   <group>     <fieldref name="title" />   </group> </query> 

to

where contenttype="my content type" or description<>null groupby title desc orderby author, authoringdate, assignedto asc 

does know how this? or have alternative suggestion solve issue? have found multiple solutions converting t-sql caml query, not other way around (i.e. http://yacamlqt.codeplex.com/ -- which retrieved example from)

thanks!

this not technically answer feel needed. approach bit backwards. sounds me trying use sharepoint ui data warehouse. if case switch approach 1 of several options outside scope of question.

data access in sharepoint supported microsoft through object model, web services or user interface. interaction outside can result in vast range of unsupported modes, corrupt data, data locks, varying result sets, security access, etc...

what sounds need bdc services. allow use data warehouse central storage , provide sharepoint native functionality of list interactions.

i'm not sure version using if want hit data directly there large amount of articles in sql community accessing data directly. there codeplex project linqtosharepoint http://linqtosharepoint.codeplex.com/ can use object support can use linq give sql-esque type functionality.