ORM for Delphi
https://www.thoughtco.com/orm-for-delphi-1058346
Working with database data in Delphi can be really simple. Drop a TQuery on a form, set the SQL property, set Active and there's your database data in a DBGrid. (You do also need a TDataSource and a connection to a database.)
Next, you'll want to insert, update and delete data, and introduce new tables. That's also easy but can get messy. It can take some finagling the correct SQL syntax before you can lay it out correctly. What is supposedly a simple task becomes slightly cumbersome.
Can all this be done relatively easily? The answer is yes -- as long as you use an ORM (Object Relational Mapper).
hcOPF - an ORM for Delphi
https://sourceforge.net/p/larryhengensopf/code/HEAD/tarball?path=/trunk
This Open Source Value Type Framework provides a base class (ThcObject) composed of attribute objects that can be automatically persisted to an object store (normally an RDBMS). An object persistence framework is essentially a library of pre-written code that takes care of the details of persisting or permanently storing an object. The object may be persisted to a text file, XML file etc., but in the business world it will most likely be to an RDBMS and for this reason, they are sometimes referred to as an ORM (Object Relational Mapper).
DObject
A macrobject DObject suite is an O/R Mapping component package to be used in Delphi. DObject O/R Mapping suite allows you to access database completely in the way of object-oriented. It includes OQL.Delphi, which is a strong-typed OQL (Object Query Language) based on native Delphi language, even you needn't write a single line of SQL statement based on the string.
SQLite3 Framework
The Synopse SQLite3 database Framework interfaces the SQlite3 database engine into pure Delphi code: database access, User Interface generation, security, i18n, and reporting are handled in a safe and fast Client/Server AJAX/RESTful model.
tiOPF
The tiOPF is an Open Source framework for Delphi that simplifies the mapping of an object oriented business model into a relational database.
TMS Aurelius
ORM framework for Delphi with full support for data manipulation, complex and advanced queries, inheritance, polymorphism, and more. Supported databases: Firebird, Interbase, Microsoft SQL Server, MySQL, NexusDB, Oracle, SQLite, PostgreSQL, DB2.
【推荐】FlashTable:表单开发界的极速跑车,让你的开发效率一路狂飙
【推荐】Flutter适配HarmonyOS 5知识地图,实战解析+高频避坑指南
【推荐】博客园的心动:当一群程序员决定开源共建一个真诚相亲平台
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步