Guidance on using Azure Virtual Desktop

We are looking for a VDI solution and choose AVD. I have gone through MS Documentation but things are quite confusing and complicated.

We have a team of 10 developers who are mainly into Biztalk and another set of 10 developers who are salesforce and other development works. They use Visual Studio, VS Code, Biztalk Server, and various other applications and services for their regular work.

Initially we thought of option to create Azure VM (20 VMs one for each developer, Windows 2019 Server Image for Biztalk devs and Windows 11 for other devs)use a Generalize VM and spin up the images using the capture of the previous generalized VM image.

But there was a point raised why can't we use Azure Virtual Desktop ? As I learned there are 2 types of host pools:

• Pooled (Multi sessions)
• Personal (Direct assignment of Host VM to each individual Developer)

This AVD Host pools/ VMs should be able to work with external SQL Servers. All the 20 VMs in AVD should be able to access, how can this be possible , what should be the connection string for granting access to external SQL Servers ?

As I understand, if I opt for Pooled AVD Hostpools, all the above 10 developers can utilize the multi sessions (whatever number of VMs we choose, ex., 5 VMs, sessions will be distributed !) they will be assigned to developers as per load balancing.

Similarly if I choose personal (10 Windows Server 2019 & another 10 Windows 11) I need to create 20 VMs and assign the 20 VMs individually to each of 20 developers in the team. is my understanding correct? Should I create 2 different workspaces and 2 application groups ?

Also I learned if I use FSLogix along with Azure Virtual Desktop (AVD) I can manage  users using profile management , will this actually help developers who uses the VS Code, Biztalk Server and other Azure services for their work daily ?

Also based on all the facts above , please help me understand which suits the requirement well, please advice, if I choose Azure Virtual Desktop over Azure VMs or vice-versa, what are the benefits or disadvantages of AVD.

Is it cost effective if I use pooled or personal AVD Host pool VMs or Azure VMs , which one suits better for us, please advice.

Experts please help me with all this confusion ? 

Kind Regards