How do I work with Postgres stored functions?

[betterthanever2]

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 func, SQLModel, Field, ARRAY

class Account(SQLModel, table=True):
    __table_args__ = {"schema": "public"}
    __tablename__ = "accounts"
    model_config = ConfigDict(from_attributes=True, arbitrary_types_allowed=True)

    id: Optional[int] = Field(default=None)
    aliases: Optional[list[str]] = Field(default=None, sa_type=ARRAY(Text))


def perform_search(search_query: str, db_session):
    with db_session as session:
        result = session.exec(func.search_in_accounts(search_query)).all()
        return result

res = perform_search("John Doe, 1989") # returns 1 or more `row`s

Description

In the example code above, perform_search function uses pgroonga under the hood to perform a search over accounts table, and returns a table, i.e. a list of row objects from it. Not sure if the internal mechanics of this function matter very much.

In python code, I have Account class that corresponds to the accounts table. When I query it with select, data gets coverted as it should.

But I'm not sure how to achieve the same when calling a stored function. How do I convert result retrieved via a stored function call into a python object?

Operating System

Linux, Windows

Operating System Details

No response

SQLModel Version

0.0.17

Python Version

3.11.9

Additional Context

No response