BUG: sql_schema does not generate dialect-specific DDL

Closes #8697 .

sqlalchemy `CreateTable` needs to be called slightly differently to create dialect-specific SQL.  See http://stackoverflow.com/questions/2128717/sqlalchemy-printing-raw-sql-from-create .