You will find a new connectivity and drivers landing page for SQL Server with .Net, Java, Python, C++, Go and PHP languages:
SQL Connectivity and Drivers – SQL Server | Microsoft Learn

As you can see, you can download, have a quick start and some code samples…
Let’s test on Python!
When I click on “Download”, I have the page for “Python SQL Driver”:
Python SQL Driver – mssql-python (Preview) – Python driver for SQL Server | Microsoft Learn

When I click on “Get Started”, I have the page for “Quickstart: Connect with the mssql-python driver for Python”:

When I click on “Code Sample”, I have the page for “Quickstart: Deploy a Python (Django, Flask, or FastAPI) web app to Azure App Service”:

Very easy to find out and simple to start with a connection to SQL Server from your development tools…
I hope others like Ruby, Spark, … will also come soon! 😉