Hey everyone!
I had to build a solution to this problem with a project that I was working on recently. I remembered coming accross this thread and thought I would share what I came up with. I did my best to package up the functionality that I thought would be helpful to other developers.
https://github.com/mbsurfer/shotgun-extensions
Importing this package will give you access to new versions of the find and find_one methods you would traditionally use with the ShotGun class.
How it works
After executing the relative find method, I check if any of the fileds requested are query fields. I then use the entity schema to construct additional queries and return the query values with the rest of the results. My goal was to make using these find functions as seamless as possible with the way they work now.
Expect these new methods to be slower than the standard find methods because of all the extra queries that need to be made, so please keep that in mind.
Feel free to reach out to me if you have any questions or suggestions.