David Hayden has posted about a Guidance Package that does data access layer generation. It’s not SubSonic, but still interesting:

Data Access Guidance Package on CodePlex - Code Generating a Data Access Layer