SQL Pretty Printer 3.6.0 released

SQL Pretty Printer is a SQL formatter tool that helps beautify your SQL code. Using hotkey functionality, SQL Pretty Printer can reformat SQL statements for a wide variety of tools including Microsoft Query Analyzer, SQL Server Management Studio (SSMS), TOAD, PL/SQL Developer, Visual Studio, Eclipse, UltraEditor and EditPlus. In addition to beautifying SQL code, SQL Pretty Printer can translate SQL code into C#, Java, PHP, Delphi and other programing languages.

Updates in 3.6.0

• [sql formatter] Fixed case expression in a plus expression formatting bug.
• [SQL server] Supports try_parse() function.
• [sql formatter] Added new format option gfmtopt.onlyinsertblankaftergo to support: BLANK LINES only after "GO" statements.
• [sql formatter] New option gfmtopt.CTE_StackColumnList to stack column list in CTE.
• [SQL Server] Supports set clause in alter table statement.
• [Oracle] Fixed can't parse syntax like: v_return_value.year in plsql.
• [Oracle] Fixed can't parse query when "log" used as table or column name.
• [SQL Server] Supports TRY_CAST function.
• [SQL Server] Supports parse function.
• [SQL Server] Fixed a bug where XML can't be a column name.
• [Oracle] Supports enabling the validate clause in alter table statement.
• [SQL Server] Supports altering index statement by adding TAlterIndexSqlStatement.
• [Oracle] Supports interval value in analytic function.
• [Oracle] Enables parse pivot/unpivot clause. Full parse tree is still not available.
• [SQL Server] Fixed can't parse begin try/end catch statement if there is no statement inside catch block.
• [SQL Server] Fixed can't parse begin try/end catch statement when it's the only statement in a stored procedure.
• [SQL Server] Supports CLOSE SYMMETRIC KEY.
• [MySQL] Supports delimiter command.
• [Oracle] Fixed can't parse sort clause in XMLAGG function.
• [format option] Added new option: analyticFunctionInNewline, default is true.
• [SQL Server] Supports offset/fetch clause in order by clause.

About Gudu Software

Gudu Software is a privately held software company focusing on providing database tools. Founded in 2002, Gudu Software has developed 5 products. With more than 800 customers in over 30 countries worldwide, Gudu Software continue to provide useful tools for SQL developers at a reasonable price, and focus investments on product development and customer support.