https://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 const

https://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.