text: Title: Is SQLModel naturally async aware ?
  Body: ### First Check
  
  - [X] I added a very descriptive title to this issue.
  - [X] I used the GitHub search to find a similar issue and didn't find it.
  - [X] I searched the SQLModel documentation, with the integrated search.
  - [X] I already searched in Google "How to X in SQLModel" and didn't find any information.
  - [X] I already read and followed all the tutorial in the docs and didn't find an answer.
  - [X] I already checked if it is not related to SQLModel but to [Pydantic](https://github.com/samuelcolvin/pydantic).
  - [X] I already checked if it is not related to SQLModel but to [SQLAlchemy](https://github.com/sqlalchemy/sqlalchemy).
  
  ### Commit to Help
  
  - [X] I commit to help with one of those options 👆
  
  ### Example Code
  
  ```python
  No code available
  ```
  
  
  ### Description
  
  Can I use SQLModel inside my FastAPI async endpoint implementations without problems ? Apparently it works. But I'm not sure if it's destroying the asynchronicity.
  
  ### Operating System
  
  Linux
  
  ### Operating System Details
  
  _No response_
  
  ### SQLModel Version
  
  0.0.4
  
  ### Python Version
  
  3.9.5
  
  ### Additional Context
  
  _No response_