Hi @Binoy Kanchanwala ,
Sorry for delay on this one. As mentioned in this Q&A thread, it is not possible to install ODBC driver due to the function due to the functions sandbox limitation and you could use Windows Containers on Azure App service in which you have control over what drivers or custom to install.
Also, to run Functions inside the container you can use the following Windows Container for Azure Functions v3 : mcr.microsoft.com/azure-functions/dotnet:3.0-nanoserver-1809 and run it App Service: Run a custom container in Azure.
Alternatively, you can use Databricks SQL Statement Execution REST API to write the results to an Azure storage and then access it in your function app.
Hope this helps.
Thanks
Saurabh
Please do not forget to "Accept the answer" wherever the information provided helps you to help others in the community.