Looks to be a DSL written in Rust that compiles the syntax into SQL. Their github repo is at https://github.com/prql/prql. I’ve never had -terrible- difficulty writing SQL, but I feel like this might be useful for complex queries. There’s some interesting interop with Python and Jupyter and it’d be neat to try out.

At a glance, some neat stuff I’ve noticed:

  • can handle different sql dialects
  • f-strings like python, essentially converting them into CONCAT
  • integration with prefect
  • DuckDB integration (I have no clue what this is as of writing - lookup?)