http://www.quora.com/What-is-the-best-free-commercial-SQL-parser-written-in-Java

I had looked at a lot of free/commercial SQL parsers myself a few months back. There was an interesting discussion at StackOverFlow(http://stackoverflow.com/questio...), though it's quite old. 

1. Commercial :The best SQLParser which I found was SQLParser( http://www.sqlparser.com/ ) . It is not free but is quite powerful. 
2. Open Source but unfriendly license for Commercial Products: There were a few open source projects , ZQL http://zql.sourceforge.net/ ) , JSQLPARSER  http://jsqlparser.sourceforge.net/ . These were fine for simple queries but I wouldn't recommend them for complex queries. Another thing with these was that they are quite old projects with no active development in a long while.
3. Create Your Own : I used this solution to create my own SQLParser using ANTLR(http://www.antlr.org). It has specific parsers for PL/SQL as well as T/SQL. Almost all the ORM frameworks use ANTLR.  You can find the grammar easily but it would require coding efforts.

Have a look at JBoss Teiid(http://www.jboss.org/teiid/) and Hibernate to see how they are doing SQL parsing.

『바른 마음』의 저자 조너선 하이트의 강연 영상

http://www.youtube.com/watch?v=IQ9EJezBBCk

원문 http://blog.naver.com/PostView.nhn?blogId=wono77&logNo=140055795091

* 아파치 모듈 컴파일 방법

아파치에 모듈을 얹어서 컴파일 방법에는 2가지가 있다.

1. 정적(Static)으로 아파치 소스와 함께 컴파일 하는 방법

2. 아파치는 재컴파일하지 않고, 모듈만 추가하는 동적 컴파일(DSO) 방법

* 아파치 모듈 개발 참고 자료들

1. 국내:

1) http://irdeal.tistory.com/30  : 1탄

2) http://irdeal.tistory.com/33 : 2탄

3) http://elenoa.tistory.com/42

4) KLDP의 관련 자료 모음(되는거 별로 없음)

http://www.ezdoum.com/stories.php?story=02/08/14/1029605

2. 국외:

1) 간단한 아파치 모듈 만들기 : 아파치 공식 사이트에서 링크하고 있는 외국 사이트 영문 튜토리얼

-설명1: http://threebit.net/tutorials/apache2_modules/tut1/tutorial1.html

-설명2: http://threebit.net/tutorials/apache2_modules/tut2/tutorial2.html

2) Introduction in developing Apache modules using C in the UNIX environment

http://articles.techrepublic.com.com/5100-10878_11-1053527.html

라인 단위로 기능 설명

3) 아파치 공식 사이트의 문서들

http://httpd.apache.org/docs/2.0/developer/

4) 아파치 API 노트

http://modules.apache.org/doc/API.html

첨부문서: 아파치 아키텍쳐 pdf