public Formatter(String sql) 
{
	
		tokens = new StringTokenizer(
				sql, 
				"()+*/-=<  >'`\"[]," + StringHelper.WHITESPACE, 
				true
			);
}

 public String format() 
{
		
		result.append(initial);
		while ( tokens.hasMoreTokens() ) {
			token = tokens.nextToken();
			lcToken = token.toLowerCase();
			if ( "'".equals(token) ) {
				String t;
				do {
					t = tokens.nextToken();
					token += t;
				} 
				while ( !"'".equals(t) );
			}		
			else if ( "\"".equals(token) ) {
				String t;
				do {
					t = tokens.nextToken();
					token += t;
				} 
				while ( !"\"".equals(t) );
			}
			if ( afterByOrSetOrFromOrSelect && ",".equals(token) ) {
				commaAfterByOrFromOrSelect();
			}
			else if ( afterOn && ",".equals(token) ) {
				commaAfterOn();
			}
			else if ( "(".equals(token) ) {
				openParen();
			}
			else if ( ")".equals(token) ) {
				closeParen();
			}
			else if ( BEGIN_CLAUSES.contains(lcToken) ) {
				beginNewClause();
			}
			else if ( END_CLAUSES.contains(lcToken) ) {
				endNewClause(); 
			}
			else if ( "select".equals(lcToken) ) {
				select();
			}
			else if ( DML.contains(lcToken) ) {
				updateOrInsertOrDelete();
			}
			else if ( "values".equals(lcToken) ) {
				values();
			}
			else if ( "on".equals(lcToken) ) {
				on();
			}
			else if ( afterBetween && lcToken.equals("and") ) {
				misc();
				afterBetween = false;
			}
			else if ( LOGICAL.contains(lcToken) ) {
				logical();
			}
			else if ( isWhitespace(token) ) {
				white();
			}
			else {
				misc();
			}
			if ( !isWhitespace( token ) ) lastToken = lcToken;
		}
		return result.toString();
}

 public static  void main(String[] args) 
{
		if ( args.length >0 ) System.out.println( 
			new Formatter( StringHelper.join(" ", args) ).format()
		);
		System.out.println( 
			new Formatter("insert into Address (city, state, zip, \"from\") values (?, ?, ?, 'insert value')").format()
		);
		System.out.println( 
			new Formatter("delete from Address where id = ? and version = ?").format()
		);
		System.out.println( 
			new Formatter("update Address set city = ?, state=?, zip=?, version = ? where id = ? and version = ?").format()
		);
		System.out.println( 
			new Formatter("update Address set city = ?, state=?, zip=?, version = ? where id in (select aid from Person)").format()
		);
		System.out.println( 
			new Formatter("select p.name, a.zipCode, count(*) from Person p left outer join Employee e on e.id = p.id and p.type = 'E' and (e.effective >? or e.effective< ?) join Address a on a.pid = p.id where upper(p.name) like 'G%' and p.age  > 100 and (p.sex = 'M' or p.sex = 'F') and coalesce( trim(a.street), a.city, (a.zip) ) is not null order by p.name asc, a.zipCode asc").format()
		);
		System.out.println( 
			new Formatter("select ( (m.age - p.age) * 12 ), trim(upper(p.name)) from Person p, Person m where p.mother = m.id and ( p.age = (select max(p0.age) from Person p0 where (p0.mother=m.id)) and p.name like ? )").format()
		);
		System.out.println( 
			new Formatter("select * from Address a join Person p on a.pid = p.id, Person m join Address b on b.pid = m.id where p.mother = m.id and p.name like ?").format()
		);
		System.out.println( 
			new Formatter("select case when p.age  > 50 then 'old' when p.age  > 18 then 'adult' else 'child' end from Person p where ( case when p.age  > 50 then 'old' when p.age  > 18 then 'adult' else 'child' end ) like ?").format()
		);
}

 public Formatter setIndentString(String indent) 
{
		this.indentString = indent;
		return this;
}

 public Formatter setInitialString(String initial) 
{
		this.initial = initial;
		return this;
}