Mapping existing SQLAlchemy ORMs to SQLModels

[havok2063]

First Check

• I added a very descriptive title here.
• I used the GitHub search to find a similar question and didn't find it.
• I searched the SQLModel documentation, with the integrated search.
• I already searched in Google "How to X in SQLModel" and didn't find any information.
• I already read and followed all the tutorial in the docs and didn't find an answer.
• I already checked if it is not related to SQLModel but to Pydantic.
• I already checked if it is not related to SQLModel but to SQLAlchemy.

Commit to Help

• I commit to help with one of those options 👆

Example Code

N/A

Description

I have an existing library of SQLAlchemy ORMs and I'm trying to build out a new FastAPI backend application. Is there a way to map existing sqla ORMs into SQLModel models, to take advantage of the built-in syncing between Pydantic + SQLalchemy?

I started manually creating new Pydantic models for each ORM, but was wondering if I could use this package instead, without redefining my SQLAlchemy ORMs, which isn't an option for me. Or is there a way to automap my sqla ORMs to Pydantic models?

Operating System

macOS

Operating System Details

No response

SQLModel Version

0.0.8

Python Version

3.10

Additional Context

No response

[MRigal]

I'm also curious to know (haven't tried out yet), if it would be possible to connect sqlalchemy's "Automap" module to create SQLModels out of a DB structure SQL file.

[joachimhuet]

If you build a tool like that I would be interested too 🍭 At the moment I'm doing a migration by rewriting all my models, it's so tiring