We’ve seen how Doctrine handles basic CRUD operations, but managing database records requires more. In this third installment focusing on Doctrine, we refine our data tools and presentation. We’ll look at whether we can use Common Table Expressions, how to get maximum-value records using ANSI SQL subqueries and Doctrine QueryBuilder, building an interactive, responsive table using Tabulator, and how to add our own Doctrine Console commands. by Oscar Merida