[whitea]

mORMot framework is also a nice example for modern Pascal... https://synopse.info/fossil/wiki?name=SQLite3+Framework

It has DDD, SOA, MVC, ORM (even for NoSql), REST, caching, logging and security features and works with Lazarus.

[zoom6628]

Looks great - have added to my research list on FPK. Thanks.

[edwinyzh]

mORMot is very full-featured and powerful! I'd suggest to start with its rich set of samples (https://github.com/synopse/mORMot/tree/master/SQLite3/Sample...) and this blog: https://tamingthemormot.wordpress.com/