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

from sqlmodel import select
from my_models import User, Comments, Preferences, Likes, Wishlist

# No overloads for "select" match the provided arguments: ...
# Would type fine for 1-4 arguments
query = select(User, Comments, Preferences, Likes, Wishlist)

Description

I am trying to write a select statement that selects 5 different SQLModel children. However I get a type error as the overloads for select are limited to 4.

Other people have had this issue too, eg here. The fix seems to be to fallback to SQLAlchemy, but then we lost the beautiful typing of SQLModel.

I am happy to fix this problem by adding extra overloads. Or is there some reason this is capped to 4? Thank you very much and I'll do my best to push the help forward!

Operating System

macOS

Operating System Details

No response

SQLModel Version

0.0.22

Python Version

3.11.9

Additional Context

No response