Add useful SQL equivalents
Opened this issue · 0 comments
vitaliihonta commented
Filtering:
- num.between(x: Num, y: Num) ???
- coalesce?
- limit
- offset
- like (https://www.postgresqltutorial.com/postgresql-tutorial/postgresql-like/)
Ordering:
- nullsFirst, nullsLast
Set operators:
- intersect
- except?
Aggregation:
- Agg without groupBy (
SELECT max(temp_lo) FROM weather;
) - Think about having
- And more from https://www.postgresql.org/docs/current/functions-aggregate.html
Window functions:
Sub query expressions