Declarative data retrieval lets you describe the result you want, while an ORM translates that request into SQL. Instead of spelling out retrieval steps and raw SQL syntax, you build a query from your programming language. section 8.3.1
Listing 8.4 C# (Entity Framework / LINQ - https://learn.microsoft.com/en-us/ef):
var users = context.Users
.Where(u => u.Age > 21 && u.IsActive)
.OrderBy(u => u.LastName)
.ToList();This C# query selects active users older than 21 and sorts them by last name. section 8.3.1
The tradeoff is less direct control over SQL syntax in exchange for queries expressed in application code. The treatment also connects ORM querying to type safety and parameterization as a defense against SQL injection; parameterization details are deferred. section 8.3.1
