Make SQBs composable for more flexible querying

k98kurz / sqloquent

Python 3+ SQL ORM system inspired by Eloquent

Other

1 stars 0 forks source link

Open k98kurz opened 1 month ago

k98kurz commented 1 month ago

Is your feature request related to a problem? Please describe.

Being able to compose query builders together to create subqueries would be a useful feature.

Describe the solution you'd like

Not sure about the exact Python syntax I want for this. It will require more thought and probably a substantial refactor.

Additional context

Some common use cases for subqueries are where in and where not in.

k98kurz commented 3 weeks ago

Another use case: select [columns] from ([subquery])

k98kurz commented 3 weeks ago

Two more:

select [columns] from [table] where [column] = ([subquery])
select [columns] from [table] join ([subquery]) [join_alias] on [table.column] = [join_alias.column]