On: Show HN: PRQL 0.2 – a better SQL

[roG0d]

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 → roG0d]

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

[2] https://docs.microsoft.com/en-us/sql/t-sql/functions/percent...

[maximilianroos → cogman10]

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

[2]: https://prql-lang.org/book/queries/dialect_and_version.html

[maximilianroos → maximilianroos]

Window example is now on the homepage, thanks for the question: https://github.com/prql/prql/pull/692