mORMot

Done.What you explained is necessary for real life tasks, but difficult to find changes in small methods and tests.The idea was, mORMot has a big test suit, maybe storing it in a DB gives a useful development analytics tool.Thanks for the feedback.

Using TServiceCustomAnswer with a custom formatting method may be indeed the easiest.

No, parenthesis should be avoided.Only basic where clause is supported by now with a list of ... AND  ... AND ...   or  a list of ... OR ... OR .... but not mixed AND + OR in the same clause, nor any parenthesis.But NOT, IS NULL, IS NOT NULL, IN (....), LIKE, and function calls are supported.

Yes, the non-expanded format is efficient and not difficult to decode.I don't see the relevance of trying other non-standard formats.

macfly has already written the solution. In my source code I use it as follows:TMyRestServer = class(TSQLRestServerDB) protected procedure DownloadData(pmSender: TSynBackgroundTimer; pmEvent: TWaitResult; const pmcMsg: RawUTF8); public ... [More] procedure Start; procedure Stop; end; procedure TMyRestServer.Start; var timer: TSynBackgroundTimer; begin timer := TimerEnable(DownloadData, FRestServiceSettings.DataUpdateInterval); if Assigned(timer) then timer.ExecuteNow(DownloadData); end; procedure TMyRestServer.Stop; begin TimerDisable(DownloadData); end;With best regardsThomas [Less]

The next logical step from Delphi may be to "optimize" the managed record finalization, just as they did for interface finalization...So there is no guarantee they would be a safer alternative.

What is the SQL value before InternalAdaptSQL() call?

I wanted to both code look alike so I can make sure that I'm testing the same code. For future work I will use V2.

Vitaly wrote: I guess this code might be slightly better since it will get the pointer just one time: with _Safe(vJSON.id)^ do for intX := 1 to 10 do AddItem(intX); or local variable can be also an option.Anyway, these are just details, of course. Yes that works also. Thanks a lot.JD

I guess you could put 'distinct(InterestColumn)' as field name, and 'SomeColumn is null' as where clause in an ORM retrieval method.