sql-formatter
sql-formatter copied to clipboard
SQL formatter written with only Java Standard Library, without dependencies.
Handle `Go` keyword as `reservedNewlineWords`. Origin SQL. ```sql alter table t1 add n_col int null go update t1 set c_con=0 ``` before ```sql ALTER TABLE t1 ADD n_col int NULL...
The query ```java SqlFormatter.of(Dialect.PlSql) .extend(cfg -> cfg.plusOperators("->")) .format("SELECT `My field with \\` back ()
Hi If "between and" go with convert function, the tools are not formatted correctly. ```sql SELECT * FROM table WHERE 1=1 and date BETWEEN str_to_date('2001-01-01', '%Y-%M-%D') AND str_to_date('2001-12-01', '%Y-%M-%D') and...
IndexedParams(List params) { List tempParam = new ArrayList(params.size()); for (Object param : params) { if (param == null){ param = "null"; }else if (param instanceof Number){ }else if (param instanceof...