Sign in Join

Live chat for Free Pascal, Lazarus, Delphi and every Pascal programmer.

Catalog · How the catalog works
Anything · Lazarus or Delphi
Random projectRandom project

SqlFluent

Write Sql Sentences inline in delphi code, without create big strings

View on GitHub

Member rating

No ratings yet.

Sign in to rate this project.

README

SqlFluent

Write Sql Sentences inline in delphi code, without create big strings

How to start

Add both dependencies in your project /src/

delphi
uses TSql, SQLPattern;

Then Create Sql expressions as you expect

delphi
procedure TForm2.Button1Click(Sender: TObject);
begin
    Memo1
    .Lines
    .Text := TMotorSql
    .Select
    .ADD('JOB', [
                 'CODIGOJOB',
                 'CODIGOJOBCFG',
                 'COFIGOJOBAGENDA',
                 'CODIGOJOBBUILD'])
    .FROM('JOBAGENDA JA'        )
    .JOINOn('JOBOBJETO JOB', 'JOB.CODIGOJOB = JA.CODIGOJOB', 'LEFT')
    .WHERE([
                 'JOB.CODIGOJOB > 1',
                 '',
                 '',
                 'JOB.CODIGOJOBBUILD > 1'])
    .GROUPBY('1,2,3,4')
    .ORDERBY('1,2,3,4')
    .TOSql;