Async, upsert get_or_create, helpers

[tuxpowered]

First Check

• I added a very descriptive title to this issue.
• I used the GitHub search to find a similar issue 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

# generic question, no code sample.

Description

I understand this is still a very very very new project, and that the current documentation is not as well vetted as FastAPI is. So if the following exists, maybe someone can point me to documentation or example and maybe I can help write it up.

1. It is not clear if sqlmodel is async aware or how to use it if it is.
2. How is sqlmodel different than say ORMAR which is async aware and uses a single shared pydantic model?
3. It appears that common helper functions of other ORMs such as upsert and get_or_create are absent from sqlmodel, is there a plan to add native support for these options?

Operating System

Linux, macOS

Operating System Details

No response

SQLModel Version

0.0.4

Python Version

3.9.5

Additional Context

No response

[perfecto25]

I was able to run in async using this tutorial

https://testdriven.io/blog/fastapi-sqlmodel/

[perfecto25]

this repo shows a good way to create an async session

https://github.com/Cedric-Magnan/fastapi-async-sqlmodel/blob/main/app.py

[iloveitaly]

👋 I was looking for the exact same helpers, so I built them into a wrapper library! It adds find_or_create_by(), upsert(), and other rails-like features. It also includes an ORM-like DX, lifecycle hooks, easy session management, and JSONB mutation tracking. Check it out! Would love to hear any feedback and have more contributions to it.