How to use the method tablesample

[santigandolfo]

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

from sqlalchemy import func

selectable = people.tablesample(
            func.bernoulli(1),
            name='alias',
            seed=func.random())
stmt = select(selectable.c.people_id)

Description

I'm trying to use the tablesample method defined in SQLAlchemy, but I can't seem to understand how to migrate it's structure from the sample code into SQLModel code.
For more context, I'm trying to get a random sample from a simple select query (with two wheres) and would prefere to do everything in the query instead of having to sample the resulting data (cause the table is really large)

Operating System

macOS

Operating System Details

No response

SQLModel Version

0.0.4

Python Version

3.9.7

Additional Context

No response

[YuriiMotov]

For further readers:

from typing import Optional

from sqlalchemy import func, tablesample
from sqlmodel import Field, SQLModel, select

class People(SQLModel, table=True):
    people_id: Optional[int] = Field(default=None, primary_key=True)
    name: str

selectable = tablesample(People, func.bernoulli(1), name="alias", seed=func.random())

stmt = select(selectable.c.people_id)

print(stmt)

Output:

SELECT alias.people_id 
FROM people AS alias TABLESAMPLE bernoulli(:bernoulli_1) REPEATABLE (random())