[Lazarus] SQL parser

[Michael Van Canneyt]

On Tue, 17 Aug 2010, Michael Schnell wrote:

> On 08/17/2010 10:10 AM, Michael Van Canneyt wrote:
>> I'm not sure I understand what you mean with this ?
>> 
> (As in many cases) I'm not writing for my own benefit, as I'm not at all a 
> typical Delphi/Lazarus user :) . )
>
> I once did a quite small project doing a kind of "embedded" server-type 
> application that high-performance database access. I did this using Delphi 
> and coding the database operation in SQL.

How else can you do database access ?

>
> Now my colleagues, the "Pascal division", often needs to do similar stuff, 
> but they don't want to write native SQL code, but use things like DBGrid and 
> "visual" thread party components to access the database, even if the screen 
> display of the application is only needed for debugging and never seen by an 
> end-user.

What are 'visual' thread party components ?

> So a means to code database operations in a more Pascal-developer friendly 
> way might be very welcome.

I still do not understand what you want to say.

If they want to create a number of classes , set some properties, and then
expect an SQL statement to roll out which can be fed to a database, then, 
yes, this will be possible. But IMHO directly writing the SQL will be 10
times faster.

If they visually want to drop some tables, specify some field names and set
some conditions, yes, this will also be possible if someone builds a visual
query builder.

Michael.