def rewrite(schema_ddl, raw_sql, target_dialect='mysql'):
    schema = sqlglot.MappingSchema(dialect=target_dialect)
    create_expressions = sqlglot.parse(schema_ddl, read=target_dialect)

    # Iterate over each CREATE expression
    for create_expr in create_expressions:
        if isinstance(create_expr, exp.Create) and create_expr.kind == 'TABLE':
            table_expression = create_expr.this

            # Extract column definitions
            columns = {}
            if isinstance(table_expression, exp.Schema):
                for column_def in table_expression.expressions:
                    if isinstance(column_def, exp.ColumnDef):
                        col_name = column_def.this.name
                        col_type = column_def.kind.sql(dialect=target_dialect)
                        columns[col_name] = col_type
                table_name = table_expression.this
            else:
                table_name = table_expression

            schema.add_table(table_name, columns)

    expression = sqlglot.parse_one(raw_sql, read=target_dialect)
    optimized_expression = optimize(expression, schema=schema, dialect=target_dialect)
    optimized_sql = optimized_expression.sql(dialect=target_dialect, pretty=True)

    print(optimized_sql)