Type hints for result objects from select

[sector119]

Hello,

What is the proper way to hint result object? I know that there is no way for SA to expose tuple content types right now.
But to make it more comfortable should we use Protocol or custom abstract model class as return type for function that return select result objects?

Like

class ResultHint(typing.Protocol):
  col1: int
  col2: str
  col3: list[int]

and use typing.Sequence[ResultHint] as return type hint?

Thanks

[zzzeek]

we dont have any documented way to type the rows with the column names, just as tuples with the individual types like Row[Tuple[int, str, list[int]]]. in 2.1 we will finally fix the tuple part and you'll get Row[int, str, list[int]]. but for the names, sure a protocol seems like the best idea.

[sector119]

Thank you, Mike !