• 0 Posts
  • 14 Comments
Joined 2 years ago
cake
Cake day: May 2nd, 2023

help-circle








  • The way I perceive PRQL is somewhat like SQLAlchemy-Core (the SQL expression layer, not the ORM). Almost a 1:1 mapping to SQL but softening the rough edges in SQL when constructing more complex queries dynamically, in particular: no function calls, no real variables, only string concatenation. While SQLAlchemy-Core lets you even extract sub-queries into variables, I don’t know about how powerful PRQL is in this regard.

    From what I see from the docs I’m rather hopeful though.