[CDE-chat] parsesql ideas

[Andre v. Z. <an...@sp...>]

Hi Everyone

I was just thinking about the parsesql function.  Could we not maintain 
an array of dialect keywords and their counterparts to reference in the 
parsesql function ?

Example:

array["1000"]["firebird"] = "top";
array["1000"]["firebird"] = "first";
array["1000"]["oracle"] = "rownum";

The 1000 is merely a numeric reference or id we can associate with the 
keyword.

select first 10 * from table

would become

select 1000 * from table

which could then be replaced by the necessary keywords for the 
applicable database.

the oracle query would become

select * from table where 1000 < 10

Anyway - the above needs work but who thinks its worth following?