New Features Log 2022

SQL Formatter SQLinForm Features

Release 6.22.10.xx (Oct. 2022)

  • Align Comma to Left Border

This is a new formatting feature several users asked for. The Comma of the SELECT statement is aligned to the left border of the SQL statement.

  • The new Option „Move Comma to left Border“ can be found in the „List“ Tab
format sql move left border
format sql align left option

Release 6.22.09 (Sept. 2022)

CASE boolean formatting

The formatting for the CASE boolean expressions has been significantly improved. The expression can now be indented to make complicated logic more readable. Hope you like it.

sql format case when
sql format case indent

Release 6.22.08 (August 2022)

New Keywords & Bug Fixes

The August 2022 Release got a few bug fixes and a couple of new keywords for SQL Server DB

Release 6.22.07 (July 2022)

New Option in the Free Version

The Free Version can now extract and format SQL code out of source code

extract sql from java

Show Saved Values in Combo Boxes

When you hover over a ComboBox, the gui now shows the value in the saved profile. This helps to keep track of changes in the profiles.

sql beautifier indent spaces option

Release 6.22.06 (June 2022)

Now ready for DB „ClickHouse„

First Formatting Rules have been implemented for ClickHouse

clickhouse database

New Options give better control over linebreaks in conditions

sql where condition
sql case conditions

Release 6.22.05 (May 2022)

Now ready for DB „Snowflake„.

sql formatter snowflake database option

 

New Color Option for Block Comments

beautify sql color block comment

 

New Option for Block Comments

sql replace block comments by line comments

 

Release 6.0.18 (April 2022)

The new Release 6.0.18 is available and now the Formatter can be integrated within DBeaver as External Formatter

DBeaver SQL Formatter

Also with Release 6.0.18 a new standard color option which allows a nice representation for the N++ Dark Mode.

sql formatter dark mode colors

The Release 6.0.18 got a few bug fixes (e.g. for the „Import Profile“) and includes now the newest parser version.

Release 6.0.17 (March 2022)

The new Desktop Release 6.0.17 is available and now includes the Windows Hotkey Feature. This allows you to use the Formatter in any Windows application using a Windows Hotkey.

The Notepad++ Plugin Release 6.0.17 got a few bug fixes and includes now the newest parser version.

Release 6.0.0 (January 2022)

The very new Release 6.0.0 will be published in February 2022. If you want to be a Beta Tester, please let me know using https://www.sqlinform.com/contact/

See the new features explained in the Help Section

I. More Databases

  • Azure
  • DB2
  • Oracle
  • MSAccess
  • MySQL
  • Informix
  • Netezza SQL
  • PostgreSQL
  • SQL Server
  • Redshift SQL
  • Sybase
  • Teradata
  • Vertica
  • Yellowbrick


II. Completely New Parser

This will make it easier to add more Databases and more keywords for parsing. If you want new Databases and keywords to be added, please add them in the forum https://forum.sqlinform.com/