BUG: sql_schema does not generate dialect-specific DDL

Release notes update
Merge pull request #8827 from artemyk/get_schema_fix_8697

BUG: sql_schema does not generate dialect-specific DDL