dynamic field selection

[braindevices]

Problem

Currently you must define your selections ahead of time and cannot dynamically select fields. This is because it is impossible to statically type queries using a dynamic syntax.

• the SQLModel of fastapi actually support dynamic field selection How to select specific columns from database table? fastapi/sqlmodel#232 (comment)
• our raw query actually return dict instead of typed model

So I think it is pretty reasonable to enable the dynamic field selection, once user choose to use it the return value will be just like the raw queries.

[ProgramRipper]

Maybe Partial Types is what you want.

[braindevices]

I am aware of partial types. But if I don't get it wrong, it is static selection not dynamic selection. I will need to allow select different field at run time.