Today I posted some samples about Search and Powershell integration. I mention about the supportability of querying sharepoint tables. I thought about it and I wanted to clarify my point of view and what is public & published.
I have listed the main areas (I'm primarly focusing on Office12) where I have seen supportability questions. If you have any question, please call your support contact or access http://support.microsoft.com/
On the other hand, there are articles as SharePoint Database Access where it is recommended to not query database but instead use the object model.
Looking back to the scenario of my original comment if you are debugging with the SQL Profiler your SSP Database and at the same time running the powershell script or getting the crawl history, you will see something like:
So you may think: "as these tables are not heavy used, a directly querying with some changes may have less locking, we should follow that", something that you may test only in you lab/dev environment.
Just thinking in the task, this may seems better, but think about the possibility that committed data may be a requirement.
Finally, should you TSQL your sharepoint database? I would say no, as:
What would be better, querying or using the object model?