It would be great to have a dedicated connector for Power Apps to perform R/W operations on Azure SQL Data Warehouse. I understand some technical challenges like non-enforced Primary Key and stuff. But, as an enthusiast of Power Apps' capabilities, I would like to see Microsoft provide us a connector that can handle all these limitations.
I understand there is a connector for use within Power Automate, but I suppose it can only view/read data from the tables. We would like to build Power Apps connected to Azure DWH and also perform editing operations via Edit Form. Based on few suggestions in the Dev-community, using SQL Server connector for this purpose throws error upon editing and submitting - 'Connector is not Valid'.