For R: rstudio/renv#1052

This looks to be a terrific integration between PRQL and DuckDB. I noticed some bits of fluff...

• The heading "Quering with PRQL" needs a "y" in "Querying"
• The intro paragraph is a little tentative. To make a stronger introduction, I would reword it like this (skip the "Introduction" paragraph):

Motivation

I wanted to compare PRQL and the latest DuckDB SQL (and other query libraries) to clarify the missing features of PRQL and highlight the latest features of DuckDB.

• PRQL is a modern language for data manipulation that compiles to SQL. Although the PRQL language is still evolving, it is easy to create complex SQL queries.
• DuckDB is a modern in-memory SQL OLAP (very fast) database management system. DuckDB is also evolving, with new features and improving syntax.

This project uses CLI, JavaScript, Python, R, etc. to combine the PRQL compiler and DuckDB database. This gives a powerful database that can be queried with a simple syntax.

Content & Credit

... the rest is OK...

(I hope I got your meaning correct...) Thanks.

Just a link to a book that compares this:
https://eitsupi.github.io/querying-with-prql/timeseries#sec-moving-ave

Very cool!

I also used an SMA like that in my presentations, as well as an EWMA which you can find in this Google Colab if you want to include that as well?
https://colab.research.google.com/drive/1asOWKjQbv6VWW9WjWR2Mer7PLmm0S0dT?usp=sharing

Originally posted by @snth in PRQL/prql#3618 (comment)