4 ms·
Then make some cases easier and fall back to the SQL we already have for the rest?
by bachmeier 5y ago
Then make some cases easier and fall back to the SQL we already have for the rest?
- Supermancho 5y agoSQL 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