Combining table fields into a single model field

[madduck]

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 searched using an independent engine "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 pydantic import computed_field
from sqlmodel import SQLModel


class Foo(SQLModel, table=True):
    field1: int
    field2: int
    field3: int

    @computed_field
    @property
    def fields(self) -> list[int]:
        return [self.field1, self.field2, self.field3]

Description

The database I am dealing with is really badly designed, and I would like to hide some of the atrocities in my models. Take the above example… is it possible to somehow make that model read the field{1…3} columns from the database, but not actually expose them on the model? Make them private somehow, and let me provide my own accessor?

I am aware that I can use Pydantic to hide these fields from __repr__ and the schemata, but I'd also like to hide them from the language server, such that field{1…3} are never offered to the coder as possible attributes of instances of the class?

Operating System

Linux

Operating System Details

Debian unstable

SQLModel Version

0.0.27

Python Version

3.13.7

Additional Context

No response