A year ago, we posted
a proposal for a modern SQL replacement
to Hacker News. It immediately sparked the interest of many people dealing with
data. The project grew a community of people who are now developing the
language, tooling, and the idea of a modern relational language. Since then
we’ve opened 1577 issues & PRs on
our main repo,
submitted 4211 comments, and made 1176 commits.
The number of stars is skyrocketing every time the project appears on Hacker
News, which we believe to be an indicator that people are eager to adopt the
language if the tooling is made accessible enough.
Where are we?
Language design & development in the last year have been focused on these areas:
-
design of basic
transforms
and their
interactions, -
small quality-of-life language features (e.g. syntax for
f-strings, dates, coalesce operator,
switch),
PRQL is now in a state where it can greatly improve the developer experience for
writing complex analytical queries, but it does require a bit of fiddling to set
up in your environment.
In the coming year, we are aiming to improve that by providing a dbt plugin and
integrations for tools like Rill-developer, Metabase, and DataGrip. Read more
about our plans and ambitions in
the roadmap.
How are people using it?
For data analytics at
SuperSimple:
We’ve been using PRQL under the hood to power complex analytics workflows at
Supersimple for more than 6 months now. The speed of iteration and response to
user feedback has been amazing during this period!PRQL is what I think SQL should have been like from day 1 and
