Exploring OpenAI Integration in Azure with Sql Azure

Dear all, how can I use Azure Cognitive Services with multiple tables from my SQL Server data source in Azure that are related? I want to then use this data in Azure Open AI Studio to perform queries on it. In other words, I want it to analyze my tables, identify relationships between them, and provide me with responses.

What alternatives do I have to use OpenAI on my relational data in SQL Server, to inquire about invoices, electronic guides for a specific client, etc.?

Is it possible to consume Azure Open AI as an API, similar to how the OpenAI API is consumed, or is it only for use within the Azure environment?