A very good TG2 tutorial is a demonstration of the film http://turbogears.org/2.0/docs/main/RestControllers.html . In it, you will get acquainted with what an application with a high level of TG2 is.
As for your MS SQL question, I agree with joeforker, this is more of a SA problem than TG. You have several options, the best of which is a very experimental code compiled by Chris Perkins based on autocode and some scripts from me. This currently works well with postgres and sqlite, we will love some MS SQL fixes :) http://bitbucket.org/percious/sqlautocode/
source share