The world of n-tier architectures is dead. Well maybe not quite dead, but it is certainly not the foundation of design for new systems that it has been for many years. The advent of cloud systems along with the improvements in development tooling has pushed architects to design scalable systems that make the most of the cloud platforms and allow the focus to shift to business logic, rather than the platforms needed to deliver applications.
If you are running SQL Server 2008 or 2008 R2, these versions are reaching the end of their support lifecycle on 9 July 2019. SQL Server 2008 and 2008 R2 End of Support means the end of security updates from Microsoft. To overcome this, Microsoft recommends upgrading to the current version of SQL Server on-premises, and/or migrating to Azure; both of these options provide you with the most advanced security, performance, and innovation.
I have been recently exploring creating sites with Flow off the back of a list. I'd done this previously with Azure Functions very successfully but wanted to see if Site Scripts and Site Designs could remove that extra step. In short: Yes you can!