TSQLParser for Delphi $20.00
Component for Borland Delphi provides the functionality of parsing the various parts of simple Structured Query Language (SQL) query statements of the form SELECT [ColumnList] FROM [TableList] WHERE [WhereClause] ORDER BY [OrderbyClause] GROUP BY [GroupByClause] HAVING [HavingClause]
When you set the SQL Property equal to a TStringList object (the way a query statement is stored as a property of a TQuery object), a TSQLParser object will return separate TString properties for each of the ColumnList, TableList, WhereClause, OrderBy, GroupBy, and Having expressions/clauses of a simple SQL query statement. This is useful in situations where you need to modify a query
at run time.