How to use the "IN" clause using the select statement

[Praveenstein]

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

# Something similar to this from sqlalchemy

session.execute(
    select(
        [MyUserTable.c.id, MyUserTable.c.name], 
        MyUserTable.c.id.in_((123, 456))
    )
).fetchall()

Description

Trying to use the "IN" clause in the sqlmodel, where I could filter out based on a list of values

Operating System

Linux

Operating System Details

No response

SQLModel Version

0.0.6

Python Version

3.10.4

Additional Context

No response

[mgurg]

Hi, try this way:

        db_setting = session.exec(select(Settings).where(Settings.id.in_([1,2,3]))).all()

UPD YuriiMotov:
Use col as @hrehfeld showed to get atocompletions.

        db_setting = session.exec(select(Settings).where(col(Settings.id).in_([1,2,3]))).all()

[higorc-turing]

Thanks, @mgurg, this works. Weirdly enough, pylance won't recognize .in_() as a member function of the attribute, so I was thinking this wouldn't work. Any idea why?

[hrehfeld]

try https://sqlmodel.tiangolo.com/tutorial/where/#type-annotations-and-errors

from sqlmodel import col
col(Settings.id).in_([1,2,3])

[higorc-turing]

I read the whole documentation and don't know how I could have missed this. Thank you, @hrehfeld!