Connection SharePoint List/DocLib to (Azure) SQL data

I'm not a SharePoint dev, but have some experience with SharePoint lists and also SQL.

However not in combination.

While researching this, I notice "Business Connectivity Services" seems to be the answer.
However it seems BCS isn't really actively worked on? Is using this future proof?

Lets take this simple example:
In a Azure SQL database we have a list of clients.
In a SharePoint list I want a choicefield with a dropdownlist populated with the names of these clients.