4 ms·
That PRQL is not composable makes it —- so far as I can see —- mostly an alternative syntax. What I’d personally really appreciate is the ability to split quer
by usgroup 4y ago
That PRQL is not composable makes it —- so far as I can see —- mostly an alternative syntax.
What I’d personally really appreciate is the ability to split queries up into individuality testable and reusable parts. I think that’d be game changing because suddenly large sql code bases become manageable.
- ernestoo 4y agoTry dbt for that
- trollied 4y agoUse CTEs (Common Table Expressions, otherwise known as "with clauses"). This actually solves some of their gripes & reasoning for creating PRQL in the first place.
- snthpy 4y agoComposability is definitely a major design goal and I think we are getting close to that. Watch this space!
- silon42 4y agoI wonder how you plan to handle the query optimizer which often behaves unpredictably as queries get more complicated.
- thelastbender12 4y agoYou might enjoy the FunSQL library; SQL verbs are represented using regular Julia objects and you pipeline them together to build bigger queries. A key difference to other SQL builders is that you assemble a tree of "tabular operations" instead of a SQL syntax tree. https://github.com/MechanicalRabbit/FunSQL.jl https://github.com/MechanicalRabbit/FunSQL.jl