Re: [CDE-chat] parsesql ideas

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

Hi Lucian

If you and I can start working on this solution immediately it would be 
good!

In firebird the expression you talked about would be implemented as

select first 1000 next 500 * from table

There is a little problem with where the keywords go but if we can 
create a middle ground for the sql which then can be put into any 
dialect it would be good.

i.e.

select first 1000 next 500 * from table = select * from table from 500 
to 1000
select * from table limit 500, 1000 = select * from table from 500 to 1000

Both statements give us the same answer in our parsesql function which 
we then translate to the applicable database with "rules" for that database.

I think we can start by working out how different SQL queries can be 
translated into either an ANSI dialect or something we come up with to 
help get the job done

Yours sincerely

Andre van Zuydam