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.
