Working with database data in Delphi can be really simple. Drop a TQuery on a form, set the SQL property, set Active and, voila, here's your database data in a DBGrid. Ok, you do need a TDataSource and a connection to a database, but that's just a few clicks away.
Now you want to insert, update and delete data. That's also easy but can get messy. You fight with the corect SQL syntax, but finally have it laid out correctly.
You introduce new tables, tables change in design ... and your simple task becomes slightly cumbersome :(
Can all this be done easily? The answer is yes: use an ORM
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).
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 to write a single line of SQL statement based on string.
InstantObjects offers: Model realization in the Delphi IDE via integrated two-way tool; Object persistence in the most common relational databases; Object presentation via standard data-aware controls.
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.
The tiOPF is an Open Source framework for Delphi that simplifies the mapping of an object oriented business model into a relational database.
ORM framewok 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.