News for hackers. Stuff that matters.
Re:Show HN: PRQL 0.2 – a better SQL by Sankozi on Tuesday June 28, 2022 @03:02AM (#31904964)
The biggest failure of SQL joins is not using declared foreign keys. For example it should be something like "JOIN USING fk_invoice_customer c" instead of repeating each time the relationship between invoice and customer entries already defined in foreign key
Re:Show HN: PRQL 0.2 – a better SQL by neamar on Tuesday June 28, 2022 @03:35AM (#31905155)
Most engines support NATURAL JOIN, which isn't perfect and has drawbacks, but allows for shorter joins.