search

collerek / ormar

python async orm with fastapi in mind and pydantic validation
https://collerek.github.io/ormar/
MIT License
1.66k stars 87 forks source link

CTE support #412

Open Masynchin opened 2 years ago

Masynchin commented 2 years ago

Is your feature request related to a problem? Please describe. I'm always frustrated when I see another async ORM without CTE. TortoiseORM, orm (from encode), and now ormar.

Describe the solution you'd like I'd like to have CTE (and especially Recursive CTE) in ormar. There is a good implementation in PeeWee library, that I use right now.

Describe alternatives you've considered

Additional context

collerek commented 2 years ago

Hi, with orms that actually try to parse the results into corresponding Models and validate the results it's always challenging to allow users to produce derived columns and subqueries and still be able to parse the result into the meaningful end models (either also derived based on input columns or manually specified somewhere).

Similar to issue #266 and corresponding discussions.

kitty-eu-org commented 1 year ago

hello, any progress on this issue?