DEPRECATED

This extension is deprecated.

Please use InsertFmt, that is the more powerful successor!

vSQLfmt

Hi, friends! This is a vscode extension for formatting SQL files🥳

Currently, it strongly focuses only on formatting INSERT queries.

(This tool is originally made by an in-house trial for productivity improvement regarding test-data generation file...!)

Current Features 🎉

✅ format 'INSERT' queries like a table!

How To Use 💻

Very EASY.

1. Install it
2. Open Command Palette(OSX: Shift + Cmd + P; Windows: Shift + Ctrl + P)
3. Run Format INSERT Queries

Known Issues 👾

We're gonna add many nice features! Please look forward to them😊

We also know many issues like the below remain, and we're gonna fix them!

• comments embedded in queries are not correctly parsed and replaced
• some varchar values are not correctly parsed

Release Notes 📓

1.0.2

• bugfix: remove lines inserted between comments.

1.0.1

• support the case in which queries other than 'INSERT' are written between 'INSERT' queries in a file (it just ignores queries other than 'INSERT').

1.0.0

• HBD🎂
• vSQLfmt gets able to format 'INSERT' queries!

Contribution 🌟

• Let's be creative and collaborative👶
• Please read CONTRIBUTING.md for the details😉