Originally posted by pando
just make sure dont let the APP Server generate the SQLs!
We don't say about which layer generate sql code, but I said about:
what architure we need to have
We can place needed part of sql code in database, if it will be good for application perfomance and that's it.