sqlinform README

SQLinForm is a SQL Formatter. It helps format SQL code into a more readable and consistent format. It rearranges the SQL statements, keywords, and clauses in a way that makes the code easier to read and understand. The formatter can also enforce coding standards and best practices, helping to improve the overall quality and maintainability of the code. SQLinForm can be used as a standalone tool, integrated into a code editor, or built into a database management system. The primary goal is to help developers write clean, efficient, and well-structured code.

Features

You can involve the SQL Formatter with the command (ctrl+shift+P) "Format SQL (SQLinForm)"

In SQL Files (.sql) you can also format using the context menu

If you select a code snippet, then only the code snippet will be formatted. If no text has been selected, the whole document will be formatted.

Demo

Extract SQL from Source Code (Free Feature)

Generate SQL in Source Code (Free Feature)

Requirements

The parser is written in C# and therefore needs a .NET runtime. It may be that you cannot run the parser. In this case a message box will appear and inform you.

Mac Users need to install .NET6 or higher.

Any remarks and questions go to info@sqlinform.com

Free and Pro Features

There are already 100+ formatting options available. The free Version is a fully functional SQL Formatter but with less options than the Pro Version. The free and pro Options are named accordingly with (Free) and (Pro) The Pro license is available at https://www.sqlinform.com and can be activated in the last setting tab 'Pro License'. After entering the License Key, check your License with the command 'Check License (SQLinForm)'

Versions

[25.3.1]-[25.3.18] - 202-03-18

Added New Formatting Options . Add BigQuery DB . for self-defined SQL Functions . for analytic functions (OVER) . new versioning system including date of publishing

[2.0.80]-[2.0.81] - 2024-07-31

Added New Formatting Options . Linebreaks for IF THEN ELSE . Indent THEN ELSE . Bug Fixes

[2.0.61]-[2.0.71] - 2024-07-23

Added New Formatting Options . No Linebreak for small SQL . No Linebreak for small CASE Statements . Align ALIAS at pre-defined position Work Profiles from Desktop App are referred instead of the Saved Profiles

[2.0.35]-[2.0.60] - 2024-03-18

Added New Formatting Options Removed bug when user dir contains a blank Work Profiles from Desktop App are referred instead of the Saved Profiles

[2.0.20]-[2.0.34] - 2024-02-04

Added New Formatting Options for INSERT,UPDATE and "My Keywords" Extension works now also for MAs OS with .NET8 as system requirement

[2.0.0]-[2.0.6] - 2024-01-01

Added New Formatting Options.

1) Define you own SQL Function Keywords. The cols/values/parms of these Function Keywords will get a linebreak inside their brackets

2) Possibiliy to shift the formatted SQL by x Spaces. This is helpful when you want to copy/paste the formatted SQL in an existing SQL statement

3) New Option 'Decimal Point is Comma'. Some Regions use the Comma as Decimal Point. In order to avoid linebreaks inside decimal numbers this option should be checked.

Release 1.8.0

Added new Formatting Options for Sub-SELECT & CTE (Pro).

Release 1.7.8

Added free Oprion "Linebrek before Statement Delimiter".

Release 1.7.7

Added the possibility to check your license credentials using the command 'Check License (SQLinForm)'.

Release 1.6.0

Added the possibility to define own Keywords in the Keywords setting tab.

Release 1.5.8

Added 2 new free commands.

• 1. "Extract & Format SQL from Source Code (SQLinForm)"
• 2. "Format SQL & Generate Source Code (SQLinForm)"

Release 1.5.5

Added 2 new free features:

• Extract SQL from Source Code (Java, C#, etc.)
• Generate Source Code for your SQL.

Release 1.0.0

Replace Logo

Release 0.049

Added engine for azdata in package.json

Release 0.048

Added Demo Video to README

Release 0.046

Version for ADS

Release 0.045

Remove typos in README