That is an ESXi-dependent deployment, and it may not be something you can reproduce in PVE/QEMU. From a boot perspective, you only need a single disk. Additional disks may be required by the application itself, but the first step is to make the system boot successfully and then address the remaining disks afterward.
Given the purpose of the VCSA, if you are migrating away from VMware, is there even value in moving this VM over? Migrate and validate business-critical VMs/Apps. Once that is complete, you can shut down the VCSA and forget about it.
An MS SQL deployment is fundamentally different from VCSA in both design and requirements. SQL Server works correctly with a virtio-scsi single controller when installed natively. I don’t have direct experience with converting an existing SQL VM, but there is no technical reason it should not work.
Blockbridge : Ultra low latency all-NVME shared storage for Proxmox - https://www.blockbridge.com/proxmox