How to fetch Archived contracts

We are building a POC now for just PQS use.
One area that we are struggling with is easily explaining why Daml doesn’t allow for easy searching of fields in other contracts or why Daml doesn’t have a foreign key concept. To be clear, the engineers know how to work with this in Daml but we are struggling communicating it to non-Daml folks. Thoughts?

Great questions, I suggest you create a separate thread for that so they don’t get lost in this thread. This seems to go a bit further than just archived contracts. We’ll make sure you’ll get an answer there.