4 ms·

I've been contributing to this project on a few little things due to my little knowledge level. But I felt like home with such a good company of people!. I not

by roG0d 4y ago

I've been contributing to this project on a few little things due to my little knowledge level. But I felt like home with such a good company of people!. I not mature enough to fully appreciate the technical potential of the project, but the good ambient, the kindness and the growth potential is for sure worthwhile. I truly encourage everyone to contribute!

cogman10 4y ago
In particular, I think this is looking pretty good and I'd want to see even more complicated examples. For example, What do window functions end up looking like? [1] What about crazy operations like calculating percentile_cont? [2] Or just in general, how would "implementation specific" queries end up looking? [1] https://www.postgresql.org/docs/current/tutorial-window.html https://www.postgresql.org/docs/current/tutorial-window.html [2] https://docs.microsoft.com/en-us/sql/t-sql/functions/percentile-cont-transact-sql?view=sql-server-ver16 https://docs.microsoft.com/en-us/sql/t-sql/functions/percent...
- maximilianroos 4y ago
  Great questions! Window functions are here [1]. (We should add these to the homepage too) Implementation specific queries can be handled by the Dialect parameter [2], though there's still lots of work to do to build that out. [1]: https://prql-lang.org/book/transforms/window.html https://prql-lang.org/book/transforms/window.html [2]: https://prql-lang.org/book/queries/dialect_and_version.html https://prql-lang.org/book/queries/dialect_and_version.html
  - maximilianroos 4y ago
    Window example is now on the homepage, thanks for the question: https://github.com/prql/prql/pull/692 https://github.com/prql/prql/pull/692