I am migrating several on-premises websites to Azure, I can choose either SharePoint 2019 hosted on PaaS, or SharePoint Online as SaaS. I have external SQL Server databases that must remain in SQL Server (can't just convert to SharePoint lists). The SQL Server databases will either remain on-premises, or move to Azure SQL or SQL Server Managed Instance. What are my possible options for read-write communication between the SharePoint site and the SQL Server database?
I could use SSRS, but some sites will require read-write, not just read.
I could use BCS, but is there a better solution that's cloud-based?
I can use Power Apps and Power Automate, but I want to know what OTHER options there are within Azure, such as Azure Functions and Logic Apps. How do I imbed them in the SharePoint site?