As recently as version 10, the SQL Formatter would align column aliases (up to maybe 20 chars) within a SELECT.
I now have version 12, and I no longer see this feature.
Is it hidden somewhere in the preferences?
Version 10 format:
SELECT
e.eid AS enterprise_id,
cci.SegmentID AS segment_id,
340 AS transaction_type,
cci.AssignmentDate AS transaction_time,
cci.OrderID AS order_id,
1 AS units,
ni.TelephoneNumber AS telnum,
90603 AS product_id
FROM table1 e
JOIN table2 cci
ON e.eid = cci.CustomerID
AND cci.DeletionDate = 0
JOIN table3 ni
ON cci.TnID = ni.TnID
WHERE e.partnerID IN( 12345, 23456 );
Version 12 format (regression):
SELECT
e.eid AS enterprise_id,
cci.SegmentID AS segment_id,
340 AS transaction_type,
cci.AssignmentDate AS transaction_time,
cci.OrderID AS order_id,
1 AS units,
ni.TelephoneNumber AS telnum,
90603 AS product_id
FROM
table1 e
JOIN table2 cci
ON e.eid = cci.CustomerID
AND cci.DeletionDate = 0
JOIN table3 ni
ON cci.TnID = ni.TnID
WHERE e.partnerID IN (1001041, 1008725);
