SQL Beautify

😀格式化你杂乱无章的sql/hql代码😀

VS Code extension that beautifies SQL(HQL).

📸 安装 Installation

VSCode Plugin Market

💡 注意 Attention

这个插件在hql语句上更加兼容，因为它是我的主要工作语言。

This extension is more compatible in Hive SQL than in other sql language (Beacuse Hive sql is my working language 0_0).

💥 特点 Features

Beautify SQL

一键美化你的SQL！请确保你使用的语言是SQL，选择需要优化的代码块，按下Alt+Shift+f即可使用！

Beatify your SQL! Make sure the language is set to SQL,then select your sql code and press Alt+Shift+f just like you normally would.

Beautify SQL DDL

一键美化你的DDL！请确保你使用的语言是SQL，选择需要优化的代码块，按下Alt+Shift+l即可使用！

Beatify your SQL DDL! Make sure the language is set to SQL,then select your sql code and press Alt+Shift+l.

Extract SQL DDL

一键从你的Insert语句中提取的DDL！请确保你使用的语言是SQL，选择需要优化的代码块，按下Alt+Shift+;即可使用！

Extract ddl from insert sql ! Make sure the language is set to SQL,then select your sql code and press Alt+Shift+;.

✨ 最新更新 What's new on 0.1.21?

你可以选择把关键词转换成大写还是小写（默认是转化大写）

You can choose convert key words to uppercase or lowercase in Settings.(Default is Uppercase)

😎 更迭日志 Release Notes

0.0.1

Initial release

0.0.4

Fix some bugs

0.0.7

Add beautify ddl

0.0.9

Support CASE WHEN auto-wrap

0.0.12

Fix some bugs of auto-wrap

0.1.7

Align words after as left

0.1.8

Fix order by auto-wrap when order by in special hql syntax like row number() over(partition by order by)

0.1.13

Fix some bugs of ddl beautify.

0.1.15

Add ddl extract.

0.1.21

Add Uppercase setting. You can choose convert key words to uppercase or lowercase.(Default is Uppercase)

0.1.22

fix some bugs

0.1.24

add hive-sql format support