Integration between AI Agent and D365 Finance and Operations

We have a requirement to fire a database query using the AI agent to find and retrieve certain information. I understood from our team that retrieving the information from a specific table may be possible, but the team is facing difficulty when retrieving the information from multiple related tables and when there are multiple conditions to consider.
Any pointer here is greatly appreciated.