Almost all languages have some sort of object representation, right? Classes with their own behavior, DTOs, records, structs, etc.,. What language are you working in? If you're coupled to a specific database provider anyway there's usually a system table you can query to get your list of tables, column names, etc., so you could almost just use one data source and only need to deal with its structure to provide all your endpoints (not really recommending this approach).

This is probably the correct solution for this use case, but obviously and objectively much harder than object.get(id=1).

I was mainly doing this in Go, posted more in a side post.