Re: SQL language parser

Tomas, i've been thinking about this also, but the difficulty is with complex queries, like sub-select and unions etc. as a simple example (dont have the braincells for a more complex one) select t.a, t.b, t.c from table_1 t where (t.a in (select d from table2 where x = y)) order by t.c > With that I mean (perhaps wishes): > > - Ability to split the common fields of a query (for ex: the > selected columns, the tables in the FROM, the WHERE part, ORDER BY,..) > - Ability to construct a query with certaing given params > - Ability to alter certain parts of a SQL statement (for ex: replace > the ORDER BY clausule with that, the selected fields by a COUNT, etc) > - ... >