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?

2

Please sign in to leave a comment.