Do you see a real possibility of using botpress as a form of "backend" to do everything you mentioned? Qdrant and SQL adapter? I know it must require APIs.
On the other hand, how do you use chain of thought for this type of query? If you are comfortable sharing an example of how does that chain of thought look like, it would help a lot.