Case PRQL SQL PRQL SQL Case Search for the first condition that evaluates to true and return its associated value. If none of the conditions match, null is returned. PR...
Date functions to_text PRQL SQL PRQL SQL PRQL SQL Date & time format specifiers Date functions These are all the functions defined in the date module: to_text Conve...
Variables PRQL SQL PRQL SQL Variables We can define a relation — similar to a CTE in SQL — as a variable with let : PRQL let top_50 = ( from employees sort...
Variables PRQL SQL PRQL SQL Variables We can define a relation — similar to a CTE in SQL — as a variable with let : PRQL let top_50 = ( from employees sort...
Language design Language design In a way PRQL is just a transpiler to SQL. This can cause its language design to gravitate toward thinking about PRQL features in terms of how t...
Case PRQL SQL PRQL SQL Case Note case is currently experimental and may change behavior in the near future PRQL uses case for both SQL’s CASE and IF statements. Here’...
Distinct PRQL SQL PRQL SQL Selecting from each group PRQL SQL PRQL SQL Roadmap Distinct PRQL doesn’t have a specific distinct keyword. Instead, use group and take 1...
Pipes PRQL SQL PRQL SQL PRQL SQL Inner Transforms PRQL SQL Pipes Pipes are the connection between transforms that make up a pipeline. The relation produced by a trans...