opteryx
opteryx copied to clipboard
mabel-dev
🦖 A SQL-on-everything Query Engine you can execute over multiple databases and file formats. Query your data, where it lives.
Perhaps something like `native('function', param1, param2)`
### Thanks for stopping by to let us know something could be better! **Is your feature request related to a problem? Please describe.** _A clear and concise description of what...
The planner should not create inner joins, it should create CROSS JOINS and filters. The optimizer should decide how to write as INNER JOIN, probably a right deep tree. To...
- [ ] issue starts in the logical planner - line 282 - [ ] ensure predicates are being pushed into CROSS JOINs - [ ] write a JOIN fuzzer...
rewrite queries with complex OR segments as UNIONed queries. as a contrived example: ~~~sql SELECT * FROM $planets WHERE (id = 1) OR (name = 'Earth') ~~~ can be written...
Carried forward from 0.4 - [ ] APPROX_DISTINCT - [ ] MODE, MOST_COMMON - [ ] `||` arrays (append) - [ ] `-` arrays (remove items) - [ ] `date...
As optimization and performance tuning results in more code being compiled, a strategic approach is needed to help ensure ease of use and development. Something like - `opteryx.compute.list` for operations...
### Thanks for stopping by to let us know something could be better! **Is your feature request related to a problem? Please describe.** _A clear and concise description of what...
https://chat.openai.com/share/9b894eba-2a52-4ada-95e6-e694bb98d3fa
The expression tree currently cascades AND and OR conditions, e.g.: `a AND b AND c` is `((a AND b) AND c)`. This means that the engine traverses a layer in...