SQL has effectively failed, as a standard, despite it's ubiquity. It's literally being aged out, which makes for opportunities for PRQL, etc to fill pragmatic gaps.
eg the lack of default column aliasing from joins
SELECT
A.id AS A__id,
A.name AS A__name,
B.id AS B__id,
B.name AS B__name
FROM A
LEFT JOIN B
ON A.other_id = B.other_id
When you could have:
SELECT
A.*,
B.*
FORMAT (TABLE__)
FROM A
LEFT JOIN B
ON A.other_id = B.other_id
SQL has effectively failed, as a standard, despite it's ubiquity. It's literally being aged out, which makes for opportunities for PRQL, etc to fill pragmatic gaps.
eg the lack of default column aliasing from joins
When you could have: