mevdschee/pathpdo

PathPDO is a PHP library that transforms flat database query results into nested, structured data automatically. If you've ever written a SQL query that joins several tables, you know the result comes back as a grid of rows with lots of repeated values. This library takes that flat grid and organizes it into a clean hierarchy, so related data is nested where it belongs. The library works by reading your database's foreign key relationships to understand how tables connect. When you run a query that joins posts to comments, it knows that a post can have many comments, so it nests the comments inside each post. You can also manually control the output structure using a path syntax similar to JSONPath, letting you specify exactly how tables map to nested objects and arrays. If performance is a concern, you can cache the foreign key metadata to a file instead of querying the database schema on every request, and you can even store that cache in something like Redis for faster retrieval. A PHP developer building an API would find this useful. Consider a blog endpoint that returns users, their posts, and comments on those posts. Without this library, you'd either run multiple queries or manually post-process the flat results to build the hierarchy. With PathPDO, you write one join query and get back a structured object with posts and nested comments, ready to encode as JSON for your API response. The project is notable for how it handles the balance between automation and control. By default it infers the structure from your schema, so simple queries need no configuration. But for more complex queries, you can step in and provide explicit path mappings to override the defaults. This means you get sensible automatic behavior for common cases without being locked in when you need something specific.