To be honest, I've lost my initial enthusiasm for SubSonic and don't plan to use it going forward for anything except the scaffold for managing the db.
I found I didn't like the overhead and memory use for SubSonic is high due to a lot of string creation and concatenation. I'm happy enough with my Codesmith templates and generating real sql for each db. I also find it easier to solve problems when I can just go look at the sql statements.
Best,
Joe