Delphi-PRAXiS - CQLBr for Delph/Lazarus

It is so nice when you see how a small idea grows into a nice, rounded project!

Years age I wrote a unit that allowed you to write SQL statements as Pascal code (

GpSQLBuilder). This has allowed me to write a code like this:

query:=CreateGpSQLBuilder;
query
.Select.All
.From(DB_TEST)
.OrderBy(
query.&Case
.When([COL_2,'< 0']).&Then(COL_3)
.&Else(COL_4)
.&End);It was a small project with minimum support -- as long as it generated SQL code that I've needed, I was fine with it. Much of the SQL language support was missing, there was no support for different SQL dialects and so on ...

Luckilly,*Isaque Pinheiro liked the idea and converted it into a full-fledged library with support for multiple SQL dialects, much more complete SQL language support, units tests, installer, a ton of samples and more.*

Read more »[SIZE=-2]--- Published under the

Creative Commons Attribution 3.0 license[/SIZE]