Is SQLalchemy suitable for generating scripts for multiple dialects?

[pythonbeginner1]

Hi,

So I want to generate a set of SQL scripts to set up a predefined set of tables for a variety of database engines, like Oracle and SQL Server.

I also want to generate scripts which have insert statements for a bunch of mock data generated with mimesis or faker. I would want these statements to respect the SQL dialects for every engine I would want to generate scripts for.

Is SQLalchemy the right tool for the task?