I use it mostly for reverse engineering a model on top of a legacy database when working on projects to clean and migrate that data. I seen some very legacy da

I use it mostly for reverse engineering a model on top of a legacy database when working on projects to clean and migrate that data. I seen some very legacy database 'designs' and have never failed to model them with a combination of sqlalchemy join mapping, datatype mapping and some object properties in python for cases that are simpler to just express as list comprehensions. You end up with some data quality rules / Transformation logic you can reasonably share with business users. On the Load end I normally do that via sql bulk inserts as using an ORM just adds too much overhead and not enough control.