3 ms·
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 lik
by 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 agoGreat 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 agoWindow example is now on the homepage, thanks for the question: https://github.com/prql/prql/pull/692 https://github.com/prql/prql/pull/692