Automatically include AS for aliases
Simply put, is there a way to have the formatter add AS for any aliases for tables?
E.g.
Before formatting:
SELECT a.account_id, CONCAT(i.fname, ' ', i.lname) AS i_name, b.name AS b_name
FROM account a
LEFT JOIN individual i USING (cust_id)
LEFT JOIN business b USING (cust_id);
After formatting:
SELECT a.account_id, CONCAT(i.fname, ' ', i.lname) AS i_name, b.name AS b_name
FROM account AS a
LEFT JOIN individual AS i USING (cust_id)
LEFT JOIN business AS b USING (cust_id);
Somewhat related, could the INNER JOIN autocompletion also use AS with the aliases it generates?
Please sign in to leave a comment.