While writing the application using Apple's WebObjects, in exactly what kind of situation we need to use the Raw SQL in place of using the standard EOF generated queries? I dont find any perfect situation for it.
It's recomended to use raw sql access when you are going to do read-only or "non-interactive batch applications". Also, it is better to use aggregate functions (avg, sum) provided by the database, instead of calculating over an in memory collection of objects.
Hope this helps.
You showed up just in time for the waffles! And this tiny ad:
Building a Better World in your Backyard by Paul Wheaton and Shawn Klassen-Koop