I’ve been following this closely. Out of all the SQL replacements I’ve seen, I think this has the best chance at succeeding, since it transpiles easily to SQL and it’s not tied to any particular DB or tool.
Love this. I haven’t written any R code in years, but I do miss the simple and intuitive syntax of dplyr and the rest of the tidyverse. PRQL looks like it is built on the same philosophy. Can’t wait for it to get fully integrated into dbt.
This looks cool, but I wish it were easier to use. I see you can create files and then have prql’s vscode extension create sql files out of them, but I don’t always have a separate file per query in my app development projects. It would be nice if they could convert snippets - maybe code comments containing prql - that it converts into sql strings.
That’s because the tooling is not there quite yet. For what you describe, that would have to be implemented by the compiler bindings for your language. And it’s not that hard - basically one function. But yeah, not there yet.
You are not logged in. However you can subscribe from another Fediverse account, for example Lemmy or Mastodon. To do this, paste the following into the search field of your instance: [email protected]
This is the official technology community of Lemmy.ml for all news related to creation and use of technology, and to facilitate civil, meaningful discussion around it.
Ask in DM before posting product reviews or ads. All such posts otherwise are subject to removal.
Rules:
1: All Lemmy rules apply
2: Do not post low effort posts
3: NEVER post naziped*gore stuff
4: Always post article URLs or their archived version URLs as sources, NOT screenshots. Help the blind users.
5: personal rants of Big Tech CEOs like Elon Musk are unwelcome (does not include posts about their companies affecting wide range of people)
6: no advertisement posts unless verified as legitimate and non-exploitative/non-consumerist
7: crypto related posts, unless essential, are disallowed
LOL spot on tho
I’ve been following this closely. Out of all the SQL replacements I’ve seen, I think this has the best chance at succeeding, since it transpiles easily to SQL and it’s not tied to any particular DB or tool.
I totally agree with you
Love this. I haven’t written any R code in years, but I do miss the simple and intuitive syntax of dplyr and the rest of the tidyverse. PRQL looks like it is built on the same philosophy. Can’t wait for it to get fully integrated into dbt.
I use SPQR for my data transformation. All queries lead to Rome
This looks cool, but I wish it were easier to use. I see you can create files and then have prql’s vscode extension create sql files out of them, but I don’t always have a separate file per query in my app development projects. It would be nice if they could convert snippets - maybe code comments containing prql - that it converts into sql strings.
That’s because the tooling is not there quite yet. For what you describe, that would have to be implemented by the compiler bindings for your language. And it’s not that hard - basically one function. But yeah, not there yet.