trilogy-data / trilogy-data/pytrilogy
Better Syntactic Differentiation for Group Bys
Nobody has claimed this yet.
- Dominant language
- Python
- Stars
- 61
- Forks
- 3
- Avg merge
- 7h 18m
- Merged PRs (30d)
- 43
Description
Problem Statement
Right now, inline group bys look like
sum(x) by a,b,c
This becomes awkward when they are passed into functions
select round(sum(x) by a,b,c, d)
Is that a round by D characters, or a sum by a,b,c,d?
Proposed Solution
Unsure yet!
Alternatives Considered
Please briefly describe which alternatives, if any, have been considered, including merits of alternate approaches and
tradeoffs being made.
Additional Context
Please provide any other information that may be relevant.
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
The issue names no files, tests, or entry points. Start by locating the parser and handling for inline GROUP BY expressions, then compare how function arguments are currently parsed; done means selecting and documenting a syntax that unambiguously distinguishes the grouping expression from surrounding function arguments.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- python, sql
- Domain
- compilers
- Issue type
- Feature
- Difficulty
- 5/5
- Estimated time
- Over a week
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 25/100