2 ms·
Could you provide some examples of non trivial SQL queries expressed as PRQL and then what PRQL actually produces as a result? As others have suggested, I do w
by usgroup 4y ago
Could you provide some examples of non trivial SQL queries expressed as PRQL and then what PRQL actually produces as a result?
As others have suggested, I do wonder how optimal the translation is for non trivial cases because that often matters both for cost and performance reasons.
- aerzen 4y agohttps://prql-lang.org/book/examples/employees.html https://prql-lang.org/book/examples/employees.html The goal is for compiler to be smart about what SQL constructs are used. We want to lift at least some burden of regard for performance from user and pass it to the compiler. But there is a caveat: when writing SQL, you only have to know roughly how does the database optimizer work. When writing PRQL, you also have to know a little about PRQL compiler.