@Waghe Pranav Suhas Welcome to Microsoft to Microsoft Q&A Forum, Thank you for posting your query here!
Azure Stack HCI is really just a hypervisor running VM's in a cluster. So the Database that you eventually run on these servers is not really much of an impact to the HCI. The only thing that would cross my mind is when you look at licensing but technically any DB should work as long as it can run in the VM
Deploy SQL Server on Azure Stack HCI
Please let us know if you have any further queries. I’m happy to assist you further.
----------
Please do not forget to and “up-vote” wherever the information provided helps you, this can be beneficial to other community members.