Convert JSON to SQL format and vice versa in VS Code.
Features
Parse JSON in the active editor and format it as SQL statements.
Replace the content of the active document with the formatted SQL.
Change the language mode of the editor to SQL for syntax highlighting.
Parse SQL in the active editor and format it as JSON.
Installation
Open Visual Studio Code.
Go to the Extensions view by clicking on the square icon in the sidebar or pressing Ctrl+Shift+X.
Search for "Jsonb SQL Formatter".
Click Install to install the extension.
Reload Visual Studio Code to activate the extension.
Usage
JSON to SQL
Open a JSON document in Visual Studio Code.
Right-click inside the JSON document to open the context menu.
Select "Format JSON to SQL and Change Language Mode" from the menu.
The JSON content will be formatted as SQL and replaced in the document.
The language mode of the editor will be changed to SQL for syntax highlighting.
Alternatively, you can use the command palette (Ctrl+Shift+P) and search for "JSON to SQL Formatter" or "SQL to JSON Formatter" to run the respective command.
Requirements
Visual Studio Code version 1.52.0 or higher.
Extension Settings
This extension does not provide any customizable settings.
Known Issues
None.
Release Notes
1.0.0
Initial release of JSON to SQL and SQL to JSON Formatter.
Contributing
Contributions are welcome! Fork the repository, make your changes, and submit a pull request.
License
This project is licensed under the MIT License - see the LICENSE file for details.
