Re:Show HN: PRQL in PostgreSQL
by nightpool on Monday February 19, 2024 @11:55AM
(#39431949)
that works for top-1 but breaks completely if you want to extend it to top-2
[ Parent
| on HN ]
The example was asking for top 1. Yes, you are correct that you'd have to switch up to a window function to handle top-n+1.
Do you believe these cases are common enough to warrant discarding the tools and training available to SQL? Are you also certain that PRQL doesn't have corner cases where SQL is more concise and/or easier to understand?