Atomic Query Construction

Every Laravel app has the same query written in five places.

A where chain in the controller, a copy in the export, another in the API, a fourth in a report, and a fifth nobody remembers. Change a filter and you hunt for all five.

Atomic Query Construction (AQC) gives each query one home: one class, one handle() method, parameters in and results out. You write it once and call it everywhere.

Inside the pattern

• The rules of the pattern, in the order you need them.
• A complete example class that serves an admin panel, a storefront and a mobile API from one query.
• How to handle relations, pagination, sorting and filters without a pile of if statements.
• How to keep classes small as your app grows.
• How AQC compares with Repository, CQRS and GraphQL, so you know where it fits.

Who it is for

Laravel and PHP developers with a codebase that has outlived its first year. You know controllers should be thin. You have tried a service layer, a repository or both, and the queries still sprawl.

About the author

I created AQC and wrote the book that explains it. I have spent more than 15 years building software, as a developer and as a CTO.

What you download

A PDF, available right after payment. The download link also arrives by email.

Before you buy

Do I need to know a framework other than Laravel? No. The examples use Laravel and Eloquent. The pattern is plain PHP classes.

Can I try the pattern before I buy? Yes. The blog explains the core idea for free, starting with Introducing the Atomic Query Construction (AQC) Design Pattern.