Align AS aliases in your SQL-like scripts, including Spark SQL, T-SQL, and more.
Improve the readability of your queries in seconds.
Designed for professional data practitioners.
Before
with w_1 as (
select col_1 as f1
, col_2 as f2
, cast(col_3 as int) as f3
from tbl_a as t1
join tbl_b as t2
)
select *
from w_1 as a
join other_tbl as b
After
with w_1 as (
select col_1 as f1
, col_2 as f2
, cast(col_3 as int) as f3
from tbl_a as t1
join tbl_b as t2
)
select *
from w_1 as a
join other_tbl as b
Features
Instantly formats blocks of code to vertically align the AS keyword used for field and table aliases,
Ignores AS keyword inside other statements (e.g., with clause CTE and CAST(... AS INT)) to prevent unnecessary formatting.
Activate with a simple keyboard shortcut or via the Command Palette.
Usage
Open any scripts containing SQL-like syntax.
Press the keyboard shortcut to format the active file:
Windows/Linux:Ctrl+Alt+A
Mac:Cmd+Alt+A
Alternatively, open the Command Palette (Ctrl+Shift+P), type Prettify SQL Aliases, and press Enter.
